APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_REP_PRODUCTS_GT

Line 47: ,okl_rep_products_gt pdt_gt

43: ,min(bkg_trx.transaction_date) bkg_transaction_date
44: FROM okl_trx_contracts_all bkg_trx
45: ,okl_k_headers khr
46: ,okl_trx_types_b try
47: ,okl_rep_products_gt pdt_gt
48: WHERE bkg_trx.tcn_type = 'BKG'
49: AND bkg_trx.try_id = try.id
50: AND try.trx_type_class = 'BOOKING'
51: -- Booking Transaction should be related to the Input Ledger

Line 336: TYPE rep_pdts_tbl_type IS TABLE OF okl_rep_products_gt%ROWTYPE

332: WHERE params.report_id = p_report_id
333: AND params.parameter_type_code = 'PRODUCT'
334: AND params.param_num_value1 = pdt.id;
335:
336: TYPE rep_pdts_tbl_type IS TABLE OF okl_rep_products_gt%ROWTYPE
337: INDEX BY BINARY_INTEGER;
338: l_report_pdts_tbl rep_pdts_tbl_type;
339:
340: l_api_version CONSTANT NUMBER := 1;

Line 415: INSERT INTO okl_rep_products_gt VALUES l_report_pdts_tbl(i);

411: END IF;
412:
413: -- Finally insert the list of Products figured out
414: FORALL i IN l_report_pdts_tbl.FIRST .. l_report_pdts_tbl.LAST
415: INSERT INTO okl_rep_products_gt VALUES l_report_pdts_tbl(i);
416:
417: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
418: 'End: populate_products' );
419: -- Set the Return Status and return back

Line 653: ,okl_rep_products_gt pdt_gt

649: ,okl_ae_tmpt_sets_all aes
650: ,okl_st_gen_tmpt_sets_all gts
651: ,okl_reports_b rep
652: ,okl_report_trx_params rtryp
653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
655: ,hr_operating_units ou
656: ,xle_entity_profiles le
657: ,gl_ledgers_v ledger

Line 765: ,okl_rep_products_gt pdt_gt

761: ,okl_ae_tmpt_sets_all aes
762: ,okl_st_gen_tmpt_sets_all gts
763: ,okl_reports_b rep
764: ,okl_report_trx_params rtryp
765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
767: ,hr_operating_units ou
768: ,xle_entity_profiles le
769: ,gl_ledgers_v ledger

Line 892: ,okl_rep_products_gt pdt_gt

888: ,xla_event_types_vl xvl
889: -- OLM Reconciliation Report Definitions Table
890: ,okl_reports_b rep
891: ,okl_report_trx_params rtryp
892: ,okl_rep_products_gt pdt_gt
893: -- To fetch Names
894: ,gl_code_combinations_kfv glcc
895: ,hr_operating_units ou
896: ,xle_entity_profiles le

Line 1039: ,okl_rep_products_gt pdt_gt

1035: ,gl_je_lines gl
1036: -- OKL Report Definition Tables
1037: ,okl_reports_b rep
1038: ,okl_report_trx_params rtryp
1039: ,okl_rep_products_gt pdt_gt
1040: -- To fetch Names
1041: ,gl_code_combinations_kfv glcc
1042: ,hr_operating_units ou
1043: ,xle_entity_profiles le

Line 1271: ,okl_rep_products_gt pdt_gt

1267: ,okl_strm_type_v sty
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp
1271: ,okl_rep_products_gt pdt_gt
1272: -- To fetch Names
1273: ,hr_operating_units ou
1274: ,xle_entity_profiles le
1275: ,gl_ledgers_v ledger

Line 1398: ,okl_rep_products_gt pdt_gt

1394: ,xla_event_types_vl xvl
1395: -- OLM Reconciliation Report Entities
1396: ,okl_reports_b rep
1397: ,okl_report_trx_params rtryp
1398: ,okl_rep_products_gt pdt_gt
1399: -- To fetch Names
1400: ,hr_operating_units ou
1401: ,xle_entity_profiles le
1402: ,gl_ledgers_v ledger

Line 1525: ,okl_rep_products_gt pdt_gt

1521: ,xla_ae_lines xl
1522: -- OLM Reconciliation Report Entities
1523: ,okl_reports_b rep
1524: ,okl_report_trx_params rtryp
1525: ,okl_rep_products_gt pdt_gt
1526: -- To fetch Names
1527: ,hr_operating_units ou
1528: ,xle_entity_profiles le
1529: ,gl_ledgers_v ledger

Line 1681: ,okl_rep_products_gt pdt_gt

1677: ,gl_code_combinations_kfv glcc
1678: -- OLM Reconciliation Report Entities
1679: ,okl_reports_b rep
1680: ,okl_report_trx_params rtryp
1681: ,okl_rep_products_gt pdt_gt
1682: -- To fetch Names
1683: ,hr_operating_units ou
1684: ,xle_entity_profiles le
1685: ,gl_ledgers_v ledger

Line 1922: ,okl_rep_products_gt pdt_gt

1918: ,okl_strm_type_v sty
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp
1922: ,okl_rep_products_gt pdt_gt
1923: -- To fetch Names
1924: ,hr_operating_units ou
1925: ,gl_ledgers_v ledger
1926: WHERE -- OKL - AR Adjustment Application Predicates

Line 2028: ,okl_rep_products_gt pdt_gt

2024: ,xla_event_types_vl xvl
2025: -- OLM Reconciliation Report Entities
2026: ,okl_reports_b rep
2027: ,okl_report_trx_params rtryp
2028: ,okl_rep_products_gt pdt_gt
2029: -- To fetch Names
2030: ,hr_operating_units ou
2031: ,gl_ledgers_v ledger
2032: WHERE -- OKL - AR Adjustment Application Predicates

Line 2146: ,okl_rep_products_gt pdt_gt

2142: ,ar_distributions_all rdist
2143: -- OLM Reconciliation Report Entities
2144: ,okl_reports_b rep
2145: ,okl_report_trx_params rtryp
2146: ,okl_rep_products_gt pdt_gt
2147: -- To fetch Names
2148: ,hr_operating_units ou
2149: ,gl_ledgers_v ledger
2150: -- XLA Tables

Line 2296: ,okl_rep_products_gt pdt_gt

2292: ,ar_distributions_all rdist
2293: -- OLM Reconciliation Report Entities
2294: ,okl_reports_b rep
2295: ,okl_report_trx_params rtryp
2296: ,okl_rep_products_gt pdt_gt
2297: -- To fetch Names
2298: ,hr_operating_units ou
2299: ,gl_ledgers_v ledger
2300: -- XLA Tables

Line 2539: ,okl_rep_products_gt pdt_gt

2535: ,okl_strm_type_v sty
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp
2539: ,okl_rep_products_gt pdt_gt
2540: -- To fetch Names
2541: ,hr_operating_units ou
2542: ,xle_entity_profiles le
2543: ,gl_ledgers_v ledger

Line 2663: ,okl_rep_products_gt pdt_gt

2659: ,xla_event_types_vl xvl
2660: -- OLM Reconciliation Report Entities
2661: ,okl_reports_b rep
2662: ,okl_report_trx_params rtryp
2663: ,okl_rep_products_gt pdt_gt
2664: -- To fetch Names
2665: ,hr_operating_units ou
2666: ,xle_entity_profiles le
2667: ,gl_ledgers_v ledger

Line 2800: ,okl_rep_products_gt pdt_gt

2796: ,xla_ae_lines xl
2797: -- OLM Reconciliation Report Entities
2798: ,okl_reports_b rep
2799: ,okl_report_trx_params rtryp
2800: ,okl_rep_products_gt pdt_gt
2801: -- To fetch Names
2802: ,hr_operating_units ou
2803: ,xle_entity_profiles le
2804: ,gl_ledgers_v ledger

Line 2965: ,okl_rep_products_gt pdt_gt

2961: ,gl_je_lines gl
2962: -- OLM Reconciliation Report Entities
2963: ,okl_reports_b rep
2964: ,okl_report_trx_params rtryp
2965: ,okl_rep_products_gt pdt_gt
2966: -- To fetch Names
2967: ,hr_operating_units ou
2968: ,xle_entity_profiles le
2969: ,gl_ledgers_v ledger

Line 4800: FROM okl_rep_products_gt pdt_gt

4796: -- Step 1: Case (C)
4797: OR value11_num -- Product Id
4798: NOT IN
4799: ( SELECT product_id
4800: FROM okl_rep_products_gt pdt_gt
4801: )
4802: );
4803:
4804: -- Important: Step 2

Line 6035: FROM okl_rep_products_gt;

6031: --Cursor to fetch all products
6032: CURSOR C_GET_PRODUCTS
6033: IS
6034: SELECT product_id
6035: FROM okl_rep_products_gt;
6036:
6037: --Cursor to fetch all streams for given contract number and specified streams
6038: CURSOR C_MASTER_STREAMS_SPECIFIED
6039: (p_khr_id NUMBER)

Line 6389: okl_rep_products_gt pdt_gt,

6385: okl_products prod,
6386: okl_k_headers chr,
6387: okl_trx_contracts_all rbk_trx,
6388: okl_trx_contracts_all acc_trx,
6389: okl_rep_products_gt pdt_gt,
6390: OKL_TRX_TYPES_V TTY
6391: WHERE c.Link_Hist_Stream_Id = p.Id
6392: AND c.Sty_Id = st.Id
6393: AND c.Date_Current >= p.Date_Current