[Home] [Help]
107: --****************************************************
108: IF P_UNVALIDATED_TRX = 'N' THEN
109: gc_validate_inv := ' AND ai.invoice_id IN ';
110: gc_validate_inv := gc_validate_inv||' (SELECT i.invoice_id';
111: gc_validate_inv := gc_validate_inv||' FROM ap_invoices_all i, ap_invoice_distributions d';
112: gc_validate_inv := gc_validate_inv||' WHERE d.invoice_id = i.invoice_id';
113: gc_validate_inv := gc_validate_inv||' AND i.invoice_id = ai.invoice_id';
114: gc_validate_inv := gc_validate_inv||' AND d.posted_flag IN (''N'', ''Y'')'; --Included correct validation status , Bug9397505
115: gc_validate_inv := gc_validate_inv||' AND i.validation_request_id IS NULL';
173: BEGIN
174: SELECT count(1)
175: INTO ln_inv_id
176: FROM (SELECT i.invoice_id invoice_id
177: FROM ap_invoices_all i, ap_invoice_distributions d
178: WHERE d.invoice_id = i.invoice_id
179: AND i.invoice_id = p_in_inv_id
180: AND d.posted_flag IN ('N', 'Y') --Included correct validation status , Bug9397505
181: AND i.validation_request_id IS NULL
255: /* UNION ALL
256: SELECT 'A' transaction_type
257: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
258: FROM ap_invoices ai
259: ,ap_invoice_distributions_all aid
260: ,ap_invoices aipre
261: ,ap_invoice_distributions_all aidpre
262: WHERE ai.invoice_id = aid.invoice_id
263: AND aid.prepay_distribution_id = aidpre.invoice_distribution_id
257: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
258: FROM ap_invoices ai
259: ,ap_invoice_distributions_all aid
260: ,ap_invoices aipre
261: ,ap_invoice_distributions_all aidpre
262: WHERE ai.invoice_id = aid.invoice_id
263: AND aid.prepay_distribution_id = aidpre.invoice_distribution_id
264: AND aipre.invoice_id = aidpre.invoice_id
265: AND aid.accounting_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')