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'
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
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