eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PWP_INVOICE_REL dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 82: WHERE exists (select 'x' from AR_RECEIVABLE_APPLICATIONS_ALL ARA where ARA.STATUS = 'APP'

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
86: trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1)) )

Line 119: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA

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'
122: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
123: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1)))

Line 187: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA

183: ) --Bug 8204634
184: AND ((rec_date_from IS NULL AND rec_date_to IS NULL ) OR --Bug 8294296
185: EXISTS -- atleast one reciept applied between rec start and end date params
186: (SELECT 1
187: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
188: WHERE ARA.STATUS = 'APP'
189: AND ara.APPLICATION_TYPE = 'CASH'
190: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
191: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1))