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_CONS_BILL dependencies on OKL_EXT_SELL_INVS_V

Line 18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,

14: -- -------------------------------------------------------------------------
15: -- Consolidated Billing data structure
16: -- -------------------------------------------------------------------------
17: TYPE cons_bill_rec_type IS RECORD (
18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,

Line 19: currency okl_ext_sell_invs_v.currency_code%TYPE,

15: -- Consolidated Billing data structure
16: -- -------------------------------------------------------------------------
17: TYPE cons_bill_rec_type IS RECORD (
18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,

Line 20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,

16: -- -------------------------------------------------------------------------
17: TYPE cons_bill_rec_type IS RECORD (
18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
24: contract_id okc_k_headers_b.id%TYPE,

Line 21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,

17: TYPE cons_bill_rec_type IS RECORD (
18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
24: contract_id okc_k_headers_b.id%TYPE,
25: contract_number okc_k_headers_b.contract_number%TYPE,

Line 22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,

18: customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
24: contract_id okc_k_headers_b.id%TYPE,
25: contract_number okc_k_headers_b.contract_number%TYPE,
26: inf_id okl_invoice_formats_b.id%TYPE,

Line 23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,

19: currency okl_ext_sell_invs_v.currency_code%TYPE,
20: bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21: payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22: private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23: date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
24: contract_id okc_k_headers_b.id%TYPE,
25: contract_number okc_k_headers_b.contract_number%TYPE,
26: inf_id okl_invoice_formats_b.id%TYPE,
27: prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,

Line 28: org_id okl_ext_sell_invs_v.org_id%TYPE,

24: contract_id okc_k_headers_b.id%TYPE,
25: contract_number okc_k_headers_b.contract_number%TYPE,
26: inf_id okl_invoice_formats_b.id%TYPE,
27: prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
28: org_id okl_ext_sell_invs_v.org_id%TYPE,
29: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
30: kle_id okc_k_lines_b.id%TYPE,
31: sty_id okl_strm_type_v.id%TYPE,
32: xsi_id okl_ext_sell_invs_v.id%TYPE,

Line 29: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,

25: contract_number okc_k_headers_b.contract_number%TYPE,
26: inf_id okl_invoice_formats_b.id%TYPE,
27: prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
28: org_id okl_ext_sell_invs_v.org_id%TYPE,
29: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
30: kle_id okc_k_lines_b.id%TYPE,
31: sty_id okl_strm_type_v.id%TYPE,
32: xsi_id okl_ext_sell_invs_v.id%TYPE,
33: xls_id okl_xtl_sell_invs_v.id%TYPE,

Line 32: xsi_id okl_ext_sell_invs_v.id%TYPE,

28: org_id okl_ext_sell_invs_v.org_id%TYPE,
29: set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
30: kle_id okc_k_lines_b.id%TYPE,
31: sty_id okl_strm_type_v.id%TYPE,
32: xsi_id okl_ext_sell_invs_v.id%TYPE,
33: xls_id okl_xtl_sell_invs_v.id%TYPE,
34: amount okl_xtl_sell_invs_v.amount%TYPE,
35: sel_id okl_xtl_sell_invs_v.sel_id%TYPE,
36: legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006

Line 36: legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006

32: xsi_id okl_ext_sell_invs_v.id%TYPE,
33: xls_id okl_xtl_sell_invs_v.id%TYPE,
34: amount okl_xtl_sell_invs_v.amount%TYPE,
35: sel_id okl_xtl_sell_invs_v.sel_id%TYPE,
36: legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
37: );
38:
39: TYPE cons_bill_tbl_type IS TABLE OF cons_bill_rec_type
40: INDEX BY BINARY_INTEGER;

Line 43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,

39: TYPE cons_bill_tbl_type IS TABLE OF cons_bill_rec_type
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE saved_bill_rec_type IS RECORD (
43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,

Line 44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,

40: INDEX BY BINARY_INTEGER;
41:
42: TYPE saved_bill_rec_type IS RECORD (
43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,

Line 45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,

41:
42: TYPE saved_bill_rec_type IS RECORD (
43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
49: l_saved_format_id okl_invoice_formats_v.id%TYPE,

Line 46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,

42: TYPE saved_bill_rec_type IS RECORD (
43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
49: l_saved_format_id okl_invoice_formats_v.id%TYPE,
50: l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,

Line 47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,

43: l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
49: l_saved_format_id okl_invoice_formats_v.id%TYPE,
50: l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
51: l_prev_khr_id okc_k_headers_b.id%TYPE,

Line 48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,

44: l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45: l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46: l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47: l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48: l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
49: l_saved_format_id okl_invoice_formats_v.id%TYPE,
50: l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
51: l_prev_khr_id okc_k_headers_b.id%TYPE,
52: l_line_number NUMBER,