[Home] [Help]
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
318: AND gts.deal_type
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
653: ,okl_rep_products_gt pdt_gt
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
765: ,okl_rep_products_gt pdt_gt
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
885: ,xla_ae_headers xh
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
1028: ,xla_ae_headers xh
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
1268: -- OLM Reconciliation Report Entities
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
1388: -- AR Tables
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
1512: -- AR Tables
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
1663: -- AR Tables
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
1919: -- OLM Reconciliation Report Entities
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
2020: -- AR Tables
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
2140: -- AR Tables
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
2290: -- AR Tables
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
2536: -- OLM Reconciliation Report Entities
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
2653: -- AP Tables
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
2787: -- AP Tables
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
2948: -- AP Tables
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
4028: ,gl_ledgers ledger
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
4249: -- To fetch Names
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
4472: -- To fetch Names
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
4694: -- To fetch Names
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
7221: ,gl_ledgers ledger