[Home] [Help]
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
318: AND gts.deal_type
319: IN
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
653: ,okl_rep_products_gt pdt_gt
654: -- To fetch Names
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
765: ,okl_rep_products_gt pdt_gt
766: -- To fetch Names
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
885: ,xla_ae_headers xh
886: ,xla_ae_lines xl
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
1028: ,xla_ae_headers xh
1029: ,xla_ae_lines xl
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
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
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
1388: -- AR Tables
1389: ,ra_customer_trx_lines_all rcl
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
1512: -- AR Tables
1513: ,ra_customer_trx_lines_all rcl
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
1663: -- AR Tables
1664: ,ra_customer_trx_lines_all rcl
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
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
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
2020: -- AR Tables
2021: ,ar_adjustments_all radj
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
2140: -- AR Tables
2141: ,ar_adjustments_all radj
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
2290: -- AR Tables
2291: ,ar_adjustments_all radj
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
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
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
2653: -- AP Tables
2654: ,ap_invoices_all inv
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
2787: -- AP Tables
2788: ,ap_invoices_all inv
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
2948: -- AP Tables
2949: ,ap_invoices_all inv
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
4028: ,gl_ledgers ledger
4029: ,fnd_application_vl app
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
4249: -- To fetch Names
4250: ,hr_operating_units ou
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
4472: -- To fetch Names
4473: ,hr_operating_units ou
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
4694: -- To fetch Names
4695: ,hr_operating_units ou
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
7221: ,gl_ledgers ledger
7222: ,fnd_application_vl app