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 145: ra_customer_trx_lines_all arinv

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

Line 171: ra_customer_trx_lines_all arinv

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