APPS.PA_PWP_INVOICE_REL dependencies on RA_CUSTOMER_TRX

Line 57: , ra_customer_trx rac

53: ,pdi.draft_invoice_num
54: ,EI.document_header_id AP_INVOICE_ID
55: ,'AUTOLINK' link_type
56: FROM pa_projects prj
57: , ra_customer_trx rac
58: , pa_draft_invoices pdi
59: , pa_draft_invoice_items pdii
60: , pa_cust_rev_dist_lines crdl
61: , pa_expenditure_items ei

Line 106: , ra_customer_trx rac

102: , pwp.draft_invoice_num
103: , pwp.AP_INVOICE_ID
104: ,'MANUAL' link_type
105: FROM pa_projects prj
106: , ra_customer_trx rac
107: , pa_draft_invoices pdi
108: , pa_pwp_linked_invoices pwp
109: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
110: AND prj.segment1 BETWEEN start_project_num AND end_project_num

Line 164: , ra_customer_trx rac

160: THEN 'N'
161: ELSE 'Y'
162: END, 'Y') payment_status
163: FROM pa_projects prj
164: , ra_customer_trx rac
165: , pa_draft_invoices pdi
166: , pa_draft_invoice_items pdii
167: , pa_events pae
168: , pa_event_types pet

Line 771: ,RA_CUSTOMER_TRX RAC

767: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')-- INVOICE NOT YET TRANSFERED TO AR
768: OR EXISTS
769: (SELECT 1
770: FROM AR_PAYMENT_SCHEDULES_ALL ARP
771: ,RA_CUSTOMER_TRX RAC
772: WHERE ARP.STATUS = 'OP'
773: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID
774: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1
775: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDII.DRAFT_INVOICE_NUM)

Line 800: , RA_CUSTOMER_TRX RAC

796: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')
797: OR EXISTS
798: (SELECT 1
799: FROM AR_PAYMENT_SCHEDULES_ALL ARP
800: , RA_CUSTOMER_TRX RAC
801: WHERE ARP.STATUS = 'OP'
802: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID
803: AND RAC.INTERFACE_HEADER_ATTRIBUTE1 = PRJ.SEGMENT1
804: AND RAC.INTERFACE_HEADER_ATTRIBUTE2 = TO_CHAR(PDI.DRAFT_INVOICE_NUM)