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 PA_CUST_REV_DIST_LINES

Line 60: , pa_cust_rev_dist_lines crdl

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
62: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
63: AND prj.AUTO_RELEASE_PWP_INV = 'Y'
64: AND prj.segment1 BETWEEN start_project_num AND end_project_num

Line 697: pa_cust_rev_dist_lines crdl

693: FROM pa_projects_all proj,
694: pa_tasks task,
695: pa_tasks toptask,
696: pa_expenditure_items ei,
697: pa_cust_rev_dist_lines crdl
698: WHERE proj.project_id = task.project_id
699: and task.top_task_id = toptask.task_id
700: and toptask.project_id = ei.project_id
701: and task.project_id = ei.project_id

Line 744: , PA_CUST_REV_DIST_LINES CRDL

740: --Any invoices that are not interfaced to AR or interfaced but unpaid in AR
741: (
742: SELECT 1
743: FROM PA_EXPENDITURE_ITEMS EI
744: , PA_CUST_REV_DIST_LINES CRDL
745: , PA_DRAFT_INVOICE_ITEMS PDII
746: , PA_DRAFT_INVOICES PDI
747: , PA_PROJECTS PRJ
748: , PA_TASKS TASK