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_PURGE_VALIDATE_BILLING dependencies on PA_DRAFT_INVOICES_ALL

Line 125: from pa_draft_invoices_all di,

121: UNION
122: select 'Invoice has outstanding balance ' , 'PA_ARPR_INV_AMT_DUE'
123: from dual
124: where exists ( select draft_invoice_num
125: from pa_draft_invoices_all di,
126: ar_payment_schedules ar
127: where di.project_id = p_project_id
128: and di.transfer_status_code = 'A'
129: and ar.customer_trx_id = di.system_reference

Line 136: from pa_draft_invoices_all di

132: UNION
133: select 'Invoice Not Transferred and Accepted ' , 'PA_ARPR_NOT_INV_IFCD'
134: from dual
135: where exists ( select draft_invoice_num
136: from pa_draft_invoices_all di
137: where di.project_id = p_project_id
138: and di.transfer_status_code <> 'A')
139: UNION
140: select 'UBR and UER not cleared' , 'PA_ARPR_NOT_UBR_UER'