APPS.PA_PWP_INVOICE_REL dependencies on RA_CUSTOMER_TRX

Line 81: FROM ra_customer_trx rac

77: AND ei.transaction_source ='AP INVOICE'
78: AND ((rec_date_from IS NULL AND rec_date_to IS NULL ) OR
79: EXISTS
80: ( SELECT 1
81: FROM ra_customer_trx rac
82: WHERE exists (select 'x' from AR_RECEIVABLE_APPLICATIONS_ALL ARA where ARA.STATUS = 'APP'
83: AND ara.APPLICATION_TYPE = 'CASH'
84: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
85: and trunc ( ARA.APPLY_DATE ) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and

Line 117: FROM ra_customer_trx rac

113: AND pdi.project_id = PWP.project_id
114: AND ((rec_date_from IS NULL AND rec_date_to IS NULL ) OR
115: EXISTS -- atleast one reciept applied between rec start and end date params
116: (SELECT 1
117: FROM ra_customer_trx rac
118: WHERE exists ( select 'x'
119: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
120: WHERE ARA.STATUS = 'APP'
121: AND ara.APPLICATION_TYPE = 'CASH'

Line 157: , ra_customer_trx rac

153: THEN 'N'
154: ELSE 'Y'
155: END, 'Y') payment_status
156: FROM pa_projects prj
157: , ra_customer_trx rac
158: , pa_draft_invoices pdi
159: , pa_draft_invoice_items pdii
160: , pa_events pae
161: , pa_event_types pet

Line 775: ,RA_CUSTOMER_TRX RAC

771: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')-- INVOICE NOT YET TRANSFERED TO AR
772: OR EXISTS
773: (SELECT 1
774: FROM AR_PAYMENT_SCHEDULES_ALL ARP
775: ,RA_CUSTOMER_TRX RAC
776: WHERE /* ARP.STATUS = 'OP' Bug 8284969 */
777: ARP.AMOUNT_DUE_REMAINING <> 0
778: AND Sign(ARP.AMOUNT_DUE_ORIGINAL) = Sign(ARP.AMOUNT_DUE_REMAINING )
779: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID

Line 806: , RA_CUSTOMER_TRX RAC

802: AND (PDI.TRANSFER_STATUS_CODE IN ('P' ,'R','X')
803: OR EXISTS
804: (SELECT 1
805: FROM AR_PAYMENT_SCHEDULES_ALL ARP
806: , RA_CUSTOMER_TRX RAC
807: WHERE /*ARP.STATUS = 'OP' Bug 8284969 */
808: ARP.AMOUNT_DUE_REMAINING <> 0
809: AND Sign(ARP.AMOUNT_DUE_ORIGINAL) = Sign(ARP.AMOUNT_DUE_REMAINING )
810: AND RAC.CUSTOMER_TRX_ID = ARP.CUSTOMER_TRX_ID