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_ARINTF_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 100: TAI_ID OKL_TRX_AR_INVOICES_V.ID%TYPE

96: type xfer_tbl_type is table of xfer_rec_type index by binary_integer;
97: */
98:
99: TYPE xfer_rec_type IS RECORD (
100: TAI_ID OKL_TRX_AR_INVOICES_V.ID%TYPE
101: ,AMOUNT OKL_TXL_AR_INV_LNS_V.AMOUNT%TYPE
102: ,LINE_DESCRIPTION OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE
103: ,INVENTORY_ITEM_ID OKL_TXL_AR_INV_LNS_V.INVENTORY_ITEM_ID%TYPE
104: ,LINE_TYPE OKL_TXL_AR_INV_LNS_V.inv_receiv_line_code%TYPE

Line 113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE

109: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
110: ,ASSET_NUMBER OKC_K_LINES_V.NAME%TYPE
111: ,INVOICE_FORMAT_LINE_TYPE okl_invc_line_types_v.NAME%TYPE
112: ,STREAM_TYPE OKL_STRM_TYPE_V.NAME%TYPE
113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE
114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE

Line 114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE

110: ,ASSET_NUMBER OKC_K_LINES_V.NAME%TYPE
111: ,INVOICE_FORMAT_LINE_TYPE okl_invc_line_types_v.NAME%TYPE
112: ,STREAM_TYPE OKL_STRM_TYPE_V.NAME%TYPE
113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE
114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE

Line 115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE

111: ,INVOICE_FORMAT_LINE_TYPE okl_invc_line_types_v.NAME%TYPE
112: ,STREAM_TYPE OKL_STRM_TYPE_V.NAME%TYPE
113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE
114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE

Line 116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE

112: ,STREAM_TYPE OKL_STRM_TYPE_V.NAME%TYPE
113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE
114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE

Line 117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE

113: ,CURRENCY_CODE OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE
114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE

Line 118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE

114: ,currency_conversion_date OKL_TRX_AR_INVOICES_V.currency_conversion_date%TYPE
115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)

Line 119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE

115: ,currency_conversion_rate OKL_TRX_AR_INVOICES_V.currency_conversion_rate%TYPE
116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE

Line 120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE

116: ,currency_conversion_type OKL_TRX_AR_INVOICES_V.currency_conversion_type%TYPE
117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE

Line 121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE

117: ,CUST_TRX_TYPE_ID OKL_TRX_AR_INVOICES_V.CUST_TRX_TYPE_ID%TYPE
118: ,CUSTOMER_ADDRESS_ID OKL_TRX_AR_INVOICES_V.IBT_ID%TYPE
119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE

Line 123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE

119: ,CUSTOMER_BANK_ACCOUNT_ID OKL_TRX_AR_INVOICES_V.CUSTOMER_BANK_ACCOUNT_ID%TYPE
120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE

Line 124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE

120: ,CUSTOMER_ID OKL_TRX_AR_INVOICES_V.IXX_ID%TYPE
121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE

Line 125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE

121: ,HDR_DESCRIPTION OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE
122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE

Line 126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE

122: ,INVOICE_MESSAGE VARCHAR2(4000)
123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE

Line 127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE

123: ,ORG_ID OKL_TRX_AR_INVOICES_V.ORG_ID%TYPE
124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE

Line 128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE

124: ,RECEIPT_METHOD_ID OKL_TRX_AR_INVOICES_V.IRM_ID%TYPE
125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE

Line 129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE

125: ,SET_OF_BOOKS_ID OKL_TRX_AR_INVOICES_V.SET_OF_BOOKS_ID%TYPE
126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE
133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE

Line 130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE

126: ,TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_V.TAX_EXEMPT_FLAG%TYPE
127: ,TERM_ID OKL_TRX_AR_INVOICES_V.IRT_ID%TYPE
128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE
133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE
134: ,LEGAL_ENTITY_ID OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE -- for LE Uptake project 08-11-2006

Line 132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE

128: ,TRX_DATE OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE
129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE
133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE
134: ,LEGAL_ENTITY_ID OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE -- for LE Uptake project 08-11-2006
135: ,ACCOUNT_CLASS ra_interface_distributions_all.ACCOUNT_CLASS%TYPE
136: ,DIST_AMOUNT okl_trns_acc_dstrs.AMOUNT%TYPE

Line 133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE

129: ,TRX_NUMBER OKL_TRX_AR_INVOICES_V.TRX_NUMBER%TYPE
130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE
133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE
134: ,LEGAL_ENTITY_ID OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE -- for LE Uptake project 08-11-2006
135: ,ACCOUNT_CLASS ra_interface_distributions_all.ACCOUNT_CLASS%TYPE
136: ,DIST_AMOUNT okl_trns_acc_dstrs.AMOUNT%TYPE
137: ,DIST_PERCENT okl_trns_acc_dstrs.PERCENTAGE%TYPE

Line 134: ,LEGAL_ENTITY_ID OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE -- for LE Uptake project 08-11-2006

130: ,CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_V.CONSOLIDATED_INVOICE_NUMBER%TYPE
131: ,INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_V.INVOICE_FORMAT_TYPE%TYPE
132: ,INVOICE_PULL_YN OKL_TRX_AR_INVOICES_V.INVOICE_PULL_YN%TYPE
133: ,PRIVATE_LABEL OKL_TRX_AR_INVOICES_V.PRIVATE_LABEL%TYPE
134: ,LEGAL_ENTITY_ID OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE -- for LE Uptake project 08-11-2006
135: ,ACCOUNT_CLASS ra_interface_distributions_all.ACCOUNT_CLASS%TYPE
136: ,DIST_AMOUNT okl_trns_acc_dstrs.AMOUNT%TYPE
137: ,DIST_PERCENT okl_trns_acc_dstrs.PERCENTAGE%TYPE
138: ,CODE_COMBINATION_ID okl_trns_acc_dstrs.CODE_COMBINATION_ID%TYPE

Line 154: ,OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_V.OKL_SOURCE_BILLING_TRX%TYPE

150: ,uom_code mtl_system_items.primary_uom_code%TYPE
151: ,txn_id NUMBER
152: --
153: -- R12 additional columns pass to AR interface
154: ,OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_V.OKL_SOURCE_BILLING_TRX%TYPE
155: ,Investor_Agreement_Number OKL_TRX_AR_INVOICES_V.Investor_Agreement_Number%TYPE
156: ,Investor_Name OKL_TRX_AR_INVOICES_V.Investor_Name%TYPE
157: ,Quote_number OKL_TRX_QUOTES_B.quote_number%type
158: ,rbk_request_number NUMBER

Line 155: ,Investor_Agreement_Number OKL_TRX_AR_INVOICES_V.Investor_Agreement_Number%TYPE

151: ,txn_id NUMBER
152: --
153: -- R12 additional columns pass to AR interface
154: ,OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_V.OKL_SOURCE_BILLING_TRX%TYPE
155: ,Investor_Agreement_Number OKL_TRX_AR_INVOICES_V.Investor_Agreement_Number%TYPE
156: ,Investor_Name OKL_TRX_AR_INVOICES_V.Investor_Name%TYPE
157: ,Quote_number OKL_TRX_QUOTES_B.quote_number%type
158: ,rbk_request_number NUMBER
159: ,RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_V.RBK_ORI_INVOICE_NUMBER%TYPE

Line 156: ,Investor_Name OKL_TRX_AR_INVOICES_V.Investor_Name%TYPE

152: --
153: -- R12 additional columns pass to AR interface
154: ,OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_V.OKL_SOURCE_BILLING_TRX%TYPE
155: ,Investor_Agreement_Number OKL_TRX_AR_INVOICES_V.Investor_Agreement_Number%TYPE
156: ,Investor_Name OKL_TRX_AR_INVOICES_V.Investor_Name%TYPE
157: ,Quote_number OKL_TRX_QUOTES_B.quote_number%type
158: ,rbk_request_number NUMBER
159: ,RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_V.RBK_ORI_INVOICE_NUMBER%TYPE
160: ,RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_V.RBK_ORI_INVOICE_LINE_NUMBER%TYPE

Line 162: ,INF_ID OKL_TRX_AR_INVOICES_V.INF_ID%TYPE

158: ,rbk_request_number NUMBER
159: ,RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_V.RBK_ORI_INVOICE_NUMBER%TYPE
160: ,RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_V.RBK_ORI_INVOICE_LINE_NUMBER%TYPE
161: ,RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_V.RBK_ADJUSTMENT_DATE%TYPE
162: ,INF_ID OKL_TRX_AR_INVOICES_V.INF_ID%TYPE
163: ,TRY_ID OKL_TRX_TYPES_B.ID%TYPE
164: ,TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE
165: -- Bug 6744584: contingency fix, added contingency_id. racheruv
166: ,CONTINGENCY_ID OKL_STRM_TYPE_B.CONTINGENCY_ID%TYPE