[Home] [Help]
104: ,'MANUAL' link_type
105: FROM pa_projects prj
106: , ra_customer_trx rac
107: , pa_draft_invoices pdi
108: , pa_pwp_linked_invoices pwp
109: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
110: AND prj.segment1 BETWEEN start_project_num AND end_project_num
111: AND prj.project_id = pdi.project_id
112: AND pdi.customer_id = NVL(p_customer_number,pdi.customer_id )
197: 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))
198:
199: )
200: AND NOT EXISTS
201: (SELECT 1 FROM PA_PWP_LINKED_INVOICES
202: WHERE PROJECT_ID = pdi.project_id
203: AND DRAFT_INVOICE_NUM = pdi.draft_invoice_num );
204:
205: /*
259: )
260: AND NOT EXISTS -- unpaid manually linked invoices exist
261: (SELECT 1
262: FROM
263: PA_PWP_LINKED_INVOICES PWP
264: WHERE
265: PWP.AP_INVOICE_ID = EI.DOCUMENT_HEADER_ID
266: )
267: AND EXISTS -- ONLY THOSE INVOICE WHERE A PAY WHEN PAID HOLD EXISTS .
662: -- 2.Any EI's not yet revenue generated.
663: -- 3.Any Invoices that still open in AR
664: -- For Ei's with distribution rule as COST API checks
665: -- 1.if there are any Draft Invoices linked to the Supplier Invoice
666: -- in pa_pwp_linked_invoices
667: -- Assumptions : For distribution rule 'Cost' , if User wants to keep a Pay when paid hold on
668: -- the AP invoice till a draft invoice is paid , they have to manually link the
669: -- draft invoice with the Supplier Invoice.
670: --
787: -- unpaid manually linked invoices exist
788: (SELECT 1
789: FROM PA_PROJECTS PRJ
790: , PA_DRAFT_INVOICES PDI
791: , PA_PWP_LINKED_INVOICES PWP
792: WHERE PRJ.PROJECT_ID = PDI.PROJECT_ID
793: AND PDI.PROJECT_ID = PWP.PROJECT_ID -- Bug 7720228
794: AND PDI.DRAFT_INVOICE_NUM = PWP.DRAFT_INVOICE_NUM
795: AND PWP.AP_INVOICE_ID = P_INVOICE_ID