[Home] [Help]
298: CURSOR get_all_pdts_from_sys_csr( p_report_id NUMBER )
299: IS
300: SELECT pdt.NAME product_name
301: ,pdt.id product_id
302: FROM okl_products pdt;
303:
304:
305: -- The following Cursor will fetch the product if
306: -- a. The Products book classification is mentioned in the Report Definition
309: p_report_id NUMBER)
310: IS
311: SELECT pdt.NAME product_name
312: ,pdt.id product_id
313: FROM okl_products pdt
314: ,okl_ae_tmpt_sets_all aes
315: ,okl_st_gen_tmpt_sets_all gts
316: WHERE pdt.aes_id = aes.id
317: AND aes.gts_id = gts.id
327: -- Append list of products from the report too
328: SELECT pdt.NAME product_name
329: ,pdt.id product_id
330: FROM okl_report_parameters params
331: ,okl_products pdt
332: WHERE params.report_id = p_report_id
333: AND params.parameter_type_code = 'PRODUCT'
334: AND params.param_num_value1 = pdt.id;
335:
644: ,okl_trx_types_v try
645: ,okl_strm_type_v sty
646: ,okc_k_headers_all_b chr
647: ,okl_k_headers khr
648: ,okl_products pdt
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
756: ,okl_trx_types_v try
757: ,okl_strm_type_v sty
758: ,okc_k_headers_all_b chr
759: ,okl_k_headers khr
760: ,okl_products pdt
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
876: ,okl_trx_types_v try
877: ,okl_strm_type_v sty
878: ,okc_k_headers_all_b chr
879: ,okl_k_headers khr
880: ,okl_products pdt
881: ,okl_ae_tmpt_sets_all aes
882: ,okl_st_gen_tmpt_sets_all gts
883: -- SLA Entities
884: ,xla_distribution_links xd
1019: ,okl_trx_types_v try
1020: ,okl_strm_type_v sty
1021: ,okc_k_headers_all_b chr
1022: ,okl_k_headers khr
1023: ,okl_products pdt
1024: ,okl_ae_tmpt_sets_all aes
1025: ,okl_st_gen_tmpt_sets_all gts
1026: -- SLA Entities
1027: ,xla_distribution_links xd
1259: ,okl_txl_ar_inv_lns_b til
1260: ,okl_trx_ar_invoices_b tai
1261: ,okc_k_headers_all_b chr
1262: ,okl_k_headers khr
1263: ,okl_products pdt
1264: ,okl_ae_tmpt_sets_all aes
1265: ,okl_st_gen_tmpt_sets_all gts
1266: ,okl_trx_types_v try
1267: ,okl_strm_type_v sty
1379: ,okl_txl_ar_inv_lns_b til
1380: ,okl_trx_ar_invoices_b tai
1381: ,okc_k_headers_all_b chr
1382: ,okl_k_headers khr
1383: ,okl_products pdt
1384: ,okl_ae_tmpt_sets_all aes
1385: ,okl_st_gen_tmpt_sets_all gts
1386: ,okl_trx_types_v try
1387: ,okl_strm_type_v sty
1503: ,okl_txl_ar_inv_lns_b til
1504: ,okl_trx_ar_invoices_b tai
1505: ,okc_k_headers_all_b chr
1506: ,okl_k_headers khr
1507: ,okl_products pdt
1508: ,okl_ae_tmpt_sets_all aes
1509: ,okl_st_gen_tmpt_sets_all gts
1510: ,okl_trx_types_v try
1511: ,okl_strm_type_v sty
1654: ,okl_txl_ar_inv_lns_b til
1655: ,okl_trx_ar_invoices_b tai
1656: ,okc_k_headers_all_b chr
1657: ,okl_k_headers khr
1658: ,okl_products pdt
1659: ,okl_ae_tmpt_sets_all aes
1660: ,okl_st_gen_tmpt_sets_all gts
1661: ,okl_trx_types_v try
1662: ,okl_strm_type_v sty
1910: ,okl_trx_ar_invoices_b tai
1911: -- OKL Entities
1912: ,okc_k_headers_all_b chr
1913: ,okl_k_headers khr
1914: ,okl_products pdt
1915: ,okl_ae_tmpt_sets_all aes
1916: ,okl_st_gen_tmpt_sets_all gts
1917: ,okl_trx_types_v try
1918: ,okl_strm_type_v sty
2011: ,okl_trx_ar_invoices_b tai
2012: -- OKL Entities
2013: ,okc_k_headers_all_b chr
2014: ,okl_k_headers khr
2015: ,okl_products pdt
2016: ,okl_ae_tmpt_sets_all aes
2017: ,okl_st_gen_tmpt_sets_all gts
2018: ,okl_trx_types_v try
2019: ,okl_strm_type_v sty
2131: ,okl_trx_ar_invoices_b tai
2132: -- OKL Entities
2133: ,okc_k_headers_all_b chr
2134: ,okl_k_headers khr
2135: ,okl_products pdt
2136: ,okl_ae_tmpt_sets_all aes
2137: ,okl_st_gen_tmpt_sets_all gts
2138: ,okl_trx_types_v try
2139: ,okl_strm_type_v sty
2281: ,okl_trx_ar_invoices_b tai
2282: -- OKL Entities
2283: ,okc_k_headers_all_b chr
2284: ,okl_k_headers khr
2285: ,okl_products pdt
2286: ,okl_ae_tmpt_sets_all aes
2287: ,okl_st_gen_tmpt_sets_all gts
2288: ,okl_trx_types_v try
2289: ,okl_strm_type_v sty
2527: okl_txl_ap_inv_lns_all_b tpl
2528: ,okl_trx_ap_invs_all_b tap
2529: ,okc_k_headers_all_b chr
2530: ,okl_k_headers khr
2531: ,okl_products pdt
2532: ,okl_ae_tmpt_sets_all aes
2533: ,okl_st_gen_tmpt_sets_all gts
2534: ,okl_trx_types_v try
2535: ,okl_strm_type_v sty
2644: okl_txl_ap_inv_lns_all_b tpl
2645: ,okl_trx_ap_invs_all_b tap
2646: ,okc_k_headers_all_b chr
2647: ,okl_k_headers khr
2648: ,okl_products pdt
2649: ,okl_ae_tmpt_sets_all aes
2650: ,okl_st_gen_tmpt_sets_all gts
2651: ,okl_trx_types_v try
2652: ,okl_strm_type_v sty
2778: okl_txl_ap_inv_lns_all_b tpl
2779: ,okl_trx_ap_invs_all_b tap
2780: ,okc_k_headers_all_b chr
2781: ,okl_k_headers khr
2782: ,okl_products pdt
2783: ,okl_ae_tmpt_sets_all aes
2784: ,okl_st_gen_tmpt_sets_all gts
2785: ,okl_trx_types_v try
2786: ,okl_strm_type_v sty
2939: okl_txl_ap_inv_lns_all_b tpl
2940: ,okl_trx_ap_invs_all_b tap
2941: ,okc_k_headers_all_b chr
2942: ,okl_k_headers khr
2943: ,okl_products pdt
2944: ,okl_ae_tmpt_sets_all aes
2945: ,okl_st_gen_tmpt_sets_all gts
2946: ,okl_trx_types_v try
2947: ,okl_strm_type_v sty
4019: ,okl_trx_types_v try
4020: ,okl_strm_type_v sty
4021: ,okc_k_headers_all_b chr
4022: ,okl_k_headers khr
4023: ,okl_products pdt
4024: ,okl_ae_tmpt_sets_all aes
4025: ,okl_st_gen_tmpt_sets_all gts
4026: -- To fetch Names
4027: ,hr_operating_units ou
4240: ,okl_txl_ar_inv_lns_b til
4241: ,okl_trx_ar_invoices_b tai
4242: ,okc_k_headers_all_b chr
4243: ,okl_k_headers khr
4244: ,okl_products pdt
4245: ,okl_ae_tmpt_sets_all aes
4246: ,okl_st_gen_tmpt_sets_all gts
4247: ,okl_trx_types_v try
4248: ,okl_strm_type_v sty
4463: ,okl_txl_adjsts_lns_all_b ajl
4464: ,okl_trx_ar_adjsts_all_b adj
4465: ,okc_k_headers_all_b chr
4466: ,okl_k_headers khr
4467: ,okl_products pdt
4468: ,okl_ae_tmpt_sets_all aes
4469: ,okl_st_gen_tmpt_sets_all gts
4470: ,okl_trx_types_v try
4471: ,okl_strm_type_v sty
4685: ,okl_txl_ap_inv_lns_all_b tpl
4686: ,okl_trx_ap_invs_all_b tap
4687: ,okc_k_headers_all_b chr
4688: ,okl_k_headers khr
4689: ,okl_products pdt
4690: ,okl_ae_tmpt_sets_all aes
4691: ,okl_st_gen_tmpt_sets_all gts
4692: ,okl_trx_types_v try
4693: ,okl_strm_type_v sty
6070: OKL_STRM_ELEMENTS STE,
6071: OKC_K_HEADERS_ALL_B KHR,
6072: OKL_K_HEADERS KH,
6073: OKC_K_LINES_V KLE,
6074: OKL_PRODUCTS_V PRO,
6075: HR_OPERATING_UNITS OU
6076: WHERE STY.ID = STM.STY_ID
6077: AND STM.ID = STE.STM_ID
6078: AND STM.KHR_ID = KHR.ID
6101: OKL_STRM_ELEMENTS STE,
6102: OKC_K_HEADERS_ALL_B KHR,
6103: OKL_K_HEADERS KH,
6104: OKC_K_LINES_V KLE,
6105: OKL_PRODUCTS_V PRO,
6106: HR_OPERATING_UNITS OU
6107: WHERE STY.ID = STM.STY_ID
6108: AND STM.ID = STE.STM_ID
6109: AND STM.KHR_ID = KHR.ID
6158: OKL_STRM_ELEMENTS STE,
6159: OKC_K_HEADERS_ALL_B KHR,
6160: OKL_K_HEADERS KH,
6161: OKC_K_LINES_V KLE,
6162: OKL_PRODUCTS_V PRO,
6163: HR_OPERATING_UNITS OU
6164: WHERE STY.ID = STM.STY_ID
6165: AND STM.ID = STE.STM_ID
6166: AND STM.KHR_ID = KHR.ID
6189: OKL_STRM_ELEMENTS STE,
6190: OKC_K_HEADERS_ALL_B KHR,
6191: OKL_K_HEADERS KH,
6192: OKC_K_LINES_V KLE,
6193: OKL_PRODUCTS_V PRO,
6194: HR_OPERATING_UNITS OU
6195: WHERE STY.ID = STM.STY_ID
6196: AND STM.ID = STE.STM_ID
6197: AND STM.KHR_ID = KHR.ID
6381: Okl_strm_Elements pe,
6382: Okc_k_Headers_All_b khr,
6383: Okc_k_lines_v kle,
6384: hr_operating_units ou,
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,
7212: ,okl_trx_types_v try
7213: ,okl_strm_type_v sty
7214: ,okc_k_headers_all_b chr
7215: ,okl_k_headers khr
7216: ,okl_products pdt
7217: ,okl_ae_tmpt_sets_all aes
7218: ,okl_st_gen_tmpt_sets_all gts
7219: -- To fetch Names
7220: ,hr_operating_units ou