DBA Data[Home] [Help]

APPS.PA_PWP_INVOICE_REL dependencies on PA_CUST_REV_DIST_LINES

Line 57: pa_cust_rev_dist_lines crdl ,

53: AP_INVOICE_ID , 'AUTOLINK' link_type
54: FROM pa_projects prj ,
55: pa_draft_invoices pdi ,
56: pa_draft_invoice_items pdii ,
57: pa_cust_rev_dist_lines crdl ,
58: pa_expenditure_items ei ,
59: ( select distinct invoice_id
60: from ap_holds_all
61: where hold_lookup_code = 'Pay When Paid'

Line 700: pa_cust_rev_dist_lines crdl

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

Line 748: , PA_CUST_REV_DIST_LINES CRDL

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