DBA Data[Home] [Help]

APPS.AR_BILLS_MAIN dependencies on RA_CUSTOMER_TRX

Line 109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,

105: -- First Define the AssignRecType and AssignTabTyp
106:
107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,

Line 110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,

106:
107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,

Line 111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,

107: TYPE assignRecTyp is RECORD
108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,

Line 112: comments RA_CUSTOMER_TRX.comments%TYPE ,

108: (
109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,

Line 113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,

109: trx_number RA_CUSTOMER_TRX.trx_number%TYPE ,
110: doc_sequence_value RA_CUSTOMER_TRX.doc_sequence_value%TYPE ,
111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,
117: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE ,

Line 115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,

111: trx_date RA_CUSTOMER_TRX.trx_date%TYPE ,
112: comments RA_CUSTOMER_TRX.comments%TYPE ,
113: purchase_order RA_CUSTOMER_TRX.purchase_order%TYPE ,
114: invoice_currency_code AR_PAYMENT_SCHEDULES.invoice_currency_code%TYPE ,
115: customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE ,
116: payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE ,
117: amount_due_original AR_PAYMENT_SCHEDULES.amount_due_original%TYPE ,
118: amount_due_remaining AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE ,
119: acctd_amount_due_remaining AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE ,

Line 135: bill_to_site_use_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE ,

131: trx_type_type RA_CUST_TRX_TYPES.type%TYPE ,
132: receipt_method_name AR_RECEIPT_METHODS.NAME%TYPE ,
133: receipt_method_id AR_RECEIPT_METHODS.receipt_method_id%TYPE ,
134: location HZ_CUST_SITE_USES.location%type ,
135: bill_to_site_use_id RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE ,
136: bank_name ce_bank_branches_v.bank_name%TYPE ,
137: bank_branch_id ce_bank_branches_v.branch_party_id%TYPE ,
138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,

Line 141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,

137: bank_branch_id ce_bank_branches_v.branch_party_id%TYPE ,
138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );

Line 142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,

138: bank_account_id ap_bank_accounts.bank_account_id%TYPE ,
139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:

Line 143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,

139: cons_billing_number AR_CONS_INV_ALL.cons_billing_number%TYPE ,
140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;

Line 144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,

140: cons_inv_id AR_CONS_INV.cons_inv_id%TYPE ,
141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;
148:

Line 145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );

141: br_ref_customer_trx_id RA_CUSTOMER_TRX_LINES.br_ref_customer_trx_id%TYPE ,
142: br_ref_payment_schedule_id RA_CUSTOMER_TRX_LINES.br_ref_payment_schedule_id%TYPE ,
143: extended_amount RA_CUSTOMER_TRX_LINES.extended_amount%TYPE ,
144: extended_acctd_amount RA_CUSTOMER_TRX_LINES.extended_acctd_amount%TYPE ,
145: customer_trx_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE );
146:
147: AssignRec AssignRecTyp;
148:
149: