APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_TXL_AR_INV_LNS_V

Line 65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE

61: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
62: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
68: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
69: ,tld_id okl_txd_ar_ln_dtls_v.id%TYPE

Line 67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE

63: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
68: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
69: ,tld_id okl_txd_ar_ln_dtls_v.id%TYPE
70: ,amount okl_txd_ar_ln_dtls_v.amount%TYPE
71: ,tld_id_reverses okl_txd_ar_ln_dtls_v.TLD_ID_REVERSES%TYPE

Line 68: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE

64: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
65: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
66: ,til_description okl_txd_ar_ln_dtls_v.description%TYPE
67: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
68: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
69: ,tld_id okl_txd_ar_ln_dtls_v.id%TYPE
70: ,amount okl_txd_ar_ln_dtls_v.amount%TYPE
71: ,tld_id_reverses okl_txd_ar_ln_dtls_v.TLD_ID_REVERSES%TYPE
72: ,sty_id okl_txd_ar_ln_dtls_v.sty_id%TYPE

Line 99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE

95: ,currency_conversion_date okl_trx_ar_invoices_v.currency_conversion_date%TYPE
96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE

Line 100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE

96: ,org_id okl_trx_ar_invoices_v.org_id%TYPE
97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE

Line 101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE

97: ,legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE

Line 102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE

98: ,trx_number okl_trx_ar_invoices_v.trx_number%TYPE
99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE

Line 103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE

99: ,til_id okl_txl_ar_inv_lns_v.id%TYPE
100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE

Line 104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE

100: ,kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE
101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE

Line 105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE

101: ,inv_receiv_line_code okl_txl_ar_inv_lns_v.inv_receiv_line_code%TYPE
102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE

Line 106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE

102: ,til_description okl_txl_ar_inv_lns_v.description%TYPE
103: ,quantity okl_txl_ar_inv_lns_v.quantity%TYPE
104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE

Line 108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE

104: ,amount okl_txl_ar_inv_lns_v.amount%TYPE
105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE
111: ,qte_id okl_trx_ar_invoices_v.qte_id%TYPE
112: );

Line 109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE

105: ,TIL_ID_REVERSES okl_txl_ar_inv_lns_v.TIL_ID_REVERSES%TYPE
106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE
111: ,qte_id okl_trx_ar_invoices_v.qte_id%TYPE
112: );
113: TYPE ie_tbl_type2 IS TABLE OF ie_rec_type2

Line 110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE

106: ,sty_id okl_txl_ar_inv_lns_v.sty_id%TYPE
107: ,taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE
108: ,inventory_item_id okl_txl_ar_inv_lns_v.inventory_item_id%TYPE
109: ,inventory_org_id okl_txl_ar_inv_lns_v.inventory_org_id%TYPE
110: ,bank_acct_id okl_txl_ar_inv_lns_v.bank_acct_id%TYPE
111: ,qte_id okl_trx_ar_invoices_v.qte_id%TYPE
112: );
113: TYPE ie_tbl_type2 IS TABLE OF ie_rec_type2
114: INDEX BY BINARY_INTEGER;