DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 64: ,okc_k_headers_all_b CHR

60: GROUP BY bkg_trx.khr_id
61: -- Booking Transaction Date should be less than the Report To Date
62: HAVING MIN(bkg_trx.transaction_date ) < p_end_date
63: ) a
64: ,okc_k_headers_all_b CHR
65: ,okl_k_headers KHR
66: ,hr_operating_units ou
67: WHERE
68: a.contract_id = CHR.id

Line 646: ,okc_k_headers_all_b chr

642: ,okl_txl_cntrct_lns_all txl
643: ,okl_trns_acc_dstrs_all dist
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

Line 758: ,okc_k_headers_all_b chr

754: ,okl_txl_cntrct_lns_all txl
755: ,okl_trns_acc_dstrs_all dist
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

Line 878: ,okc_k_headers_all_b chr

874: ,okl_txl_cntrct_lns_all txl
875: ,okl_trns_acc_dstrs_all dist
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

Line 1021: ,okc_k_headers_all_b chr

1017: ,okl_txl_cntrct_lns_all txl
1018: ,okl_trns_acc_dstrs_all dist
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

Line 1261: ,okc_k_headers_all_b chr

1257: ,'Receivables' source
1258: FROM okl_txd_ar_ln_dtls_b txd
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

Line 1381: ,okc_k_headers_all_b chr

1377: ,'Receivables' source
1378: FROM okl_txd_ar_ln_dtls_b txd
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

Line 1505: ,okc_k_headers_all_b chr

1501: ,'Receivables' source
1502: FROM okl_txd_ar_ln_dtls_b txd
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

Line 1656: ,okc_k_headers_all_b chr

1652: ,'Receivables' source
1653: FROM okl_txd_ar_ln_dtls_b txd
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

Line 1912: ,okc_k_headers_all_b chr

1908: ,okl_txl_adjsts_lns_all_b ajl
1909: ,okl_txl_ar_inv_lns_b til
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

Line 2013: ,okc_k_headers_all_b chr

2009: ,okl_txl_adjsts_lns_all_b ajl
2010: ,okl_txl_ar_inv_lns_b til
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

Line 2133: ,okc_k_headers_all_b chr

2129: ,okl_txl_adjsts_lns_all_b ajl
2130: ,okl_txl_ar_inv_lns_b til
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

Line 2283: ,okc_k_headers_all_b chr

2279: ,okl_txl_adjsts_lns_all_b ajl
2280: ,okl_txl_ar_inv_lns_b til
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

Line 2529: ,okc_k_headers_all_b chr

2525: ,'Payables' source
2526: FROM
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

Line 2646: ,okc_k_headers_all_b chr

2642: ,'Payables' source
2643: FROM
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

Line 2780: ,okc_k_headers_all_b chr

2776: ,'Payables' source
2777: FROM
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

Line 2941: ,okc_k_headers_all_b chr

2937: ,'Payables' source
2938: FROM
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

Line 4021: ,okc_k_headers_all_b chr

4017: ,okl_txl_cntrct_lns_all txl
4018: ,okl_trx_contracts_all trx
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

Line 4242: ,okc_k_headers_all_b chr

4238: -- OLM Tables
4239: ,okl_txd_ar_ln_dtls_b txd
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

Line 4465: ,okc_k_headers_all_b chr

4461: ,ar_adjustments_all radj
4462: -- OLM Tables
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

Line 4687: ,okc_k_headers_all_b chr

4683: ,ap_invoices_all inv
4684: -- OLM Tables
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

Line 6071: OKC_K_HEADERS_ALL_B KHR,

6067: ) STREAM_PERIOD
6068: FROM OKL_STRM_TYPE_V STY,
6069: okl_streams_rep_v STM,
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

Line 6102: OKC_K_HEADERS_ALL_B KHR,

6098: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6099: FROM OKL_STRM_TYPE_V STY,
6100: okl_streams_rep_v STM,
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

Line 6159: OKC_K_HEADERS_ALL_B KHR,

6155: ) STREAM_PERIOD
6156: FROM OKL_STRM_TYPE_V STY,
6157: okl_streams_rep_v STM,
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

Line 6190: OKC_K_HEADERS_ALL_B KHR,

6186: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6187: FROM OKL_STRM_TYPE_V STY,
6188: okl_streams_rep_v STM,
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

Line 6382: Okc_k_Headers_All_b khr,

6378: okl_streams_rep_v p,
6379: Okl_strm_Type_v st,
6380: Okl_strm_Elements ce,
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,

Line 7214: ,okc_k_headers_all_b chr

7210: ,okl_txl_cntrct_lns_all txl
7211: ,okl_trx_contracts_all trx
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