Query to find Request group name to which concurrent program is attached.

Below given query will give you details for concurrent program and request group to which CP is attached details.

Query :

SELECT fcpt.user_concurrent_program_name,
       DECODE(frgu.request_unit_type,
              'P', 'Program',
              'S','Set',
              frgu.request_unit_type) Request_Unit_Type,
       fcp.concurrent_program_name short_name,
       frg.application_id,
       frg.request_group_name,
       fat.application_name,
       fa.application_short_name,
       fa.basepath
  FROM fnd_request_groups         frg,
       fnd_request_group_units    frgu,
       fnd_concurrent_programs    fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_application            fa,
       fnd_application_tl         fat
 WHERE frg.request_group_id = frgu.request_group_id
   AND frgu.request_unit_id = fcp.concurrent_program_id
   AND fcp.concurrent_program_id = fcpt.concurrent_program_id
   AND frg.application_id = fat.application_id
   AND fa.application_id = fat.application_id
   AND fcpt.language = USERENV('LANG')
   AND fat.language = USERENV('LANG')
   AND UPPER(fcpt.user_concurrent_program_name) like
       UPPER('Trial Balance - Detail');

Comments

Post a Comment

Popular posts from this blog

Query to get concurrent Program details with Parameter list and value set attached to parameter.

Image
Query : SELECT fcpt.user_concurrent_program_name,   fcp.concurrent_program_name,   fcp.concurrent_program_id,   fav.application_short_name,   fav.application_name,   fav.application_id,   fdfcuv.column_seq_num,   fdfcuv.end_user_column_name,   fdfcuv.form_left_prompt prompt,   ffvs.flex_value_set_name,   fdfcuv.enabled_flag,   fdfcuv.required_flag,   fdfcuv.display_flag FROM apps.fnd_concurrent_programs fcp,   apps.fnd_concurrent_programs_tl fcpt,   apps.fnd_descr_flex_col_usage_vl fdfcuv,   apps.fnd_application_vl fav,   apps.fnd_flex_value_sets ffvs WHERE fcp.concurrent_program_id       = fcpt.concurrent_program_id AND fav.application_id                = fcp.application_id AND fcpt.language                     = 'US' AND ffvs.flex_value_set_id           ...
Read more

AR and OM link in oracle apps / AR transaction and Sales Order join query

SELECT rcta.customer_trx_id, rcta.trx_number, rcta.trx_date, ac.customer_name, rctla.line_number inv_line_number, rctla.unit_selling_price inv_unit_selling_price, ooha.header_id, ooha.order_number, oola.line_number so_line_number, oola.line_id, oola.ordered_item, oola.ordered_quantity * oola.unit_selling_price so_amount FROM apps.ra_customer_trx_all rcta, apps.ra_customer_trx_lines_all rctla, apps.ar_customers ac, apps.oe_order_headers_all ooha, apps.oe_order_lines_all oola WHERE 1 = 1 AND rcta.customer_trx_id = rctla.customer_trx_id AND rcta.bill_to_customer_id = ac.customer_id AND ooha.header_id = oola.header_id AND rctla.interface_line_attribute6 = TO_CHAR(oola.line_id) AND rctla.interface_line_attribute1 = TO_CHAR(ooha.order_number) AND rcta.trx_number = nvl(:p_trx_number,rcta.trx_number) AND ooha.order_number = nvl(:p_order_number,ooha.order_number);
Read more

Japan Style: Architecture Interiors Design

Image
Enter the world of the stylish Japanese house, where every object in sight is a work of art. Japan Style introduces 20 special residences. With more than 200 color photographs, this book showcases the stunning beauty of old homes, and reveals how they are cared for by their owners. Traditional Japanese homes, with superbly crafted fine wood, great workmanship and seasonal interior arrangements, have an aesthetic of infinite simplicity. Unlike Japanese inns and historical buildings, the houses featured in this book are private property and are not open to public viewing. Japan Style offers a rare glimpse into the intimate world of the everyday Japanese and fascinating insight into the traditional architecture of Japan download link http://libgen.io/_ads/E7F3D5D3E376CB1E116D00AFC8E89AC4 .
Read more