APPS.PA_CC_AR_AP_TRANSFER dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 109: from ra_customer_trx_lines_all

105: and a.vendor_site_id =b.vendor_site_id;
106:
107: Cursor c_invoice_amount (p_customer_trx_id in number) is
108: select sum(extended_amount) amount
109: from ra_customer_trx_lines_all
110: where customer_trx_id = p_customer_trx_id;
111:
112:
113: Cursor c_receiver_project_task (p_project_customer_id in number,p_project_id in number) is

Line 144: ra_customer_trx_lines_all arinv

140: pdii.inv_amount pa_quantity,
141: arinv.line_number pa_cc_ar_invoice_line_num,
142: arinv.customer_trx_line_id cust_trx_line_id -- added for bug 5045406
143: FROM pa_draft_invoice_items pdii,
144: ra_customer_trx_lines_all arinv
145: -- ap_tax_codes_all aptax,
146: -- ar_vat_tax_all artax
147: where arinv.interface_line_attribute6= pdii.line_num
148: and arinv.customer_trx_id = p_customer_trx_id

Line 169: ra_customer_trx_lines_all arinv

165: pdii.inv_amount pa_quantity,
166: arinv.line_number pa_cc_ar_invoice_line_num,
167: arinv.customer_trx_line_id cust_trx_line_id -- added for bug 5045406
168: FROM pa_draft_invoice_items pdii,
169: ra_customer_trx_lines_all arinv
170: where arinv.interface_line_attribute6= pdii.line_num
171: and pdii.project_id=p_project_id
172: and pdii.draft_invoice_num=p_draft_invoice_number
173: and arinv.customer_trx_id =p_customer_trx_id