Query to find out Request set details

--Query to find out Request set details

SELECT rs.user_request_set_name "Request Set"

 , rss.display_sequence Seq

 , cp.user_concurrent_program_name "Concurrent Program"

, e.EXECUTABLE_NAME

 , e.execution_file_name

 , lv.meaning file_type

 ,fat.application_name "Application Name"

 ,fat.APPLICATION_ID

-- ,get_appl_name(e.application_id) "Application Name"

FROM apps.fnd_request_sets_vl rs

 , apps.fnd_req_set_stages_form_v rss

 , applsys.fnd_request_set_programs rsp

 , apps.fnd_concurrent_programs_vl cp

 , apps.fnd_executables e

 , apps.fnd_lookup_values lv

 , apps.fnd_application_tl fat

WHERE 1=1

and rs.application_id IN ( 101,202,222,201 )   --Pass the Application Short NAme

AND rs.application_id = rss.set_application_id

AND rs.request_set_id = rss.request_set_id

--AND rs.user_request_set_name LIKE :p_request_set_name  --Pass the User Request Set Name

AND e.APPLICATION_ID =FAT.APPLICATION_ID

AND rss.set_application_id = rsp.set_application_id

AND rss.request_set_id = rsp.request_set_id

AND rss.request_set_stage_id = rsp.request_set_stage_id

AND rsp.program_application_id = cp.application_id

AND rsp.concurrent_program_id = cp.concurrent_program_id

AND cp.executable_id = e.executable_id

AND cp.executable_application_id = e.application_id

AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'

AND lv.lookup_code = e.execution_method_code

and lv.language='US'

and fat.language='US'

AND rs.end_date_active IS NULL

ORDER BY 1,2

Recurring Jurnal Definition and Rules Information scripts

--Recurring Jurnal Definition and Rules Information  

SELECT glrb.NAME, glrb.description, glrb.attribute1,

glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description,

       glrl.entered_dr,glrl.entered_cr,grcr.recurring_header_id,

       grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR,

       grcr.AMOUNT, grcr.segment1,grcr.segment2, grcr.segment3,

       grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl,

       gl_recurring_line_calc_rules grcr

 WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

 AND glrl.RECURRING_HEADER_ID = grcr.RECURRING_HEADER_ID(+)

 AND glrl.RECURRING_LINE_NUM = grcr.RECURRING_LINE_NUM(+)

 ORDER BY glrl.RECURRING_LINE_NUM

--Recurring Jurnal Defination and Lines Informations 

SELECT glrb.NAME, glrb.description, glrb.attribute1,glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description, glrl.entered_dr,

       glrl.entered_cr

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl

  WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

--Recurring Jurnal Rule Calculations Details Informations 

SELECT grcr.recurring_header_id, grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR, grcr.AMOUNT, grcr.segment1,

       grcr.segment2, grcr.segment3, grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_line_calc_rules grcr

SELECT * FROM  GL_RECURRING_LINE_CALC_RULES

--Recurring Jurnal Defination and Rules Informations  

SELECT glrb.NAME, glrb.description, glrb.attribute1,

glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description,

       glrl.entered_dr,glrl.entered_cr,grcr.recurring_header_id,

       grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR,

       grcr.AMOUNT, grcr.segment1,grcr.segment2, grcr.segment3,

       grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl,

       gl_recurring_line_calc_rules grcr

 WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

 AND glrl.RECURRING_HEADER_ID = grcr.RECURRING_HEADER_ID(+)

 AND glrl.RECURRING_LINE_NUM = grcr.RECURRING_LINE_NUM(+)

 order by glrl.RECURRING_LINE_NUM

--Recurring Jurnal Defination and Lines Informations 

SELECT glrb.NAME, glrb.description, glrb.attribute1,glrl.recurring_header_id, glrl.recurring_line_num,

       glrl.code_combination_id, glrl.description, glrl.entered_dr,

       glrl.entered_cr

  FROM gl_recurring_batches glrb,

       gl_recurring_lines glrl

  WHERE glrb.RECURRING_BATCH_ID =  glrl.RECURRING_HEADER_ID

--Recurring Jurnal Rule Calculations Details Informations 

SELECT grcr.recurring_header_id, grcr.recurring_line_num, grcr.rule_num, grcr.OPERATOR, grcr.AMOUNT, grcr.segment1,

       grcr.segment2, grcr.segment3, grcr.segment4, grcr.segment5, grcr.segment6, grcr.ledger_currency,

       grcr.currency_type, grcr.actual_flag, grcr.amount_type

  FROM gl_recurring_line_calc_rules grcr

SELECT * FROM  GL_RECURRING_LINE_CALC_RULES

Suppliers External Bank account information details.

Suppliers External Bank account information details.

SELECT   'Bank Account at Supplier Level', sup.segment1,

          eba.*,ss.*,

          sup.vendor_name,ss.*,

          epa.org_id, NULL, NULL, eba.bank_account_num,

         piu.order_of_preference priority, eba.ext_bank_account_id

    FROM ap_suppliers sup,

         ap_supplier_sites_all ss,

         iby_external_payees_all epa,

         iby_pmt_instr_uses_all piu,

         iby_ext_bank_accounts eba

   WHERE sup.party_id = epa.payee_party_id

     AND sup.vendor_id = ss.vendor_id

     AND epa.ext_payee_id = piu.ext_pmt_party_id

     AND piu.instrument_id = eba.ext_bank_account_id

     AND sup.segment1 = '1488'

     AND epa.supplier_site_id IS NULL

     AND epa.party_site_id IS NULL