eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_K_HEADERS

Line 45: ,okl_k_headers khr

41: (
42: SELECT bkg_trx.khr_id contract_id
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

Line 65: ,okl_k_headers KHR

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
69: AND KHR.ID = CHR.ID

Line 647: ,okl_k_headers khr

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
651: ,okl_reports_b rep

Line 759: ,okl_k_headers khr

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
763: ,okl_reports_b rep

Line 879: ,okl_k_headers khr

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
883: -- SLA Entities

Line 1022: ,okl_k_headers khr

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
1026: -- SLA Entities

Line 1262: ,okl_k_headers khr

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
1266: ,okl_trx_types_v try

Line 1382: ,okl_k_headers khr

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
1386: ,okl_trx_types_v try

Line 1506: ,okl_k_headers khr

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
1510: ,okl_trx_types_v try

Line 1657: ,okl_k_headers khr

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
1661: ,okl_trx_types_v try

Line 1913: ,okl_k_headers khr

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
1917: ,okl_trx_types_v try

Line 2014: ,okl_k_headers khr

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
2018: ,okl_trx_types_v try

Line 2134: ,okl_k_headers khr

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
2138: ,okl_trx_types_v try

Line 2284: ,okl_k_headers khr

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
2288: ,okl_trx_types_v try

Line 2530: ,okl_k_headers khr

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
2534: ,okl_trx_types_v try

Line 2647: ,okl_k_headers khr

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
2651: ,okl_trx_types_v try

Line 2781: ,okl_k_headers khr

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
2785: ,okl_trx_types_v try

Line 2942: ,okl_k_headers khr

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
2946: ,okl_trx_types_v try

Line 4022: ,okl_k_headers khr

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
4026: -- To fetch Names

Line 4243: ,okl_k_headers khr

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
4247: ,okl_trx_types_v try

Line 4466: ,okl_k_headers khr

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
4470: ,okl_trx_types_v try

Line 4688: ,okl_k_headers khr

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
4692: ,okl_trx_types_v try

Line 6072: OKL_K_HEADERS KH,

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
6076: WHERE STY.ID = STM.STY_ID

Line 6103: OKL_K_HEADERS KH,

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
6107: WHERE STY.ID = STM.STY_ID

Line 6160: OKL_K_HEADERS KH,

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
6164: WHERE STY.ID = STM.STY_ID

Line 6191: OKL_K_HEADERS KH,

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
6195: WHERE STY.ID = STM.STY_ID

Line 6386: okl_k_headers chr,

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,
6390: OKL_TRX_TYPES_V TTY

Line 7215: ,okl_k_headers khr

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
7219: -- To fetch Names