APPS.AP_TP_STMT_PKG dependencies on AP_INVOICES

Line 111: gc_validate_inv := gc_validate_inv||' FROM ap_invoices_all i, ap_invoice_distributions d';

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'', ''P'')';
115: gc_validate_inv := gc_validate_inv||' AND i.validation_request_id IS NULL';

Line 177: FROM ap_invoices_all i, ap_invoice_distributions d

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', 'P')
181: AND i.validation_request_id IS NULL

Line 220: FROM ap_invoices ai

216: INTO ln_amount
217: FROM
218: ( SELECT 'I' transaction_type
219: ,SUM(NVL(ai.invoice_amount * NVL(ai.exchange_rate,1),0)) accounted_amount
220: FROM ap_invoices ai
221: WHERE ai.vendor_id = p_in_vendor_id
222: AND ai.vendor_site_id = p_in_vendor_site_id
223: AND ai.gl_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')
224: AND ai.invoice_currency_code = NVL2(P_CURRENCY,DECODE(P_CURRENCY,'ANY',ai.invoice_currency_code,P_CURRENCY),ai.invoice_currency_code)

Line 229: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)

225: AND ai.org_id = p_in_org_id
226: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y'
227: AND P_UNVALIDATED_TRX = 'N')
228: OR P_UNVALIDATED_TRX = 'Y')
229: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
230: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
231: ,'UNACCOUNTED','N'
232: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
233: AND ((P_UNAPPROVED_TRX = 'N'

Line 232: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))

228: OR P_UNVALIDATED_TRX = 'Y')
229: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
230: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
231: ,'UNACCOUNTED','N'
232: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
233: AND ((P_UNAPPROVED_TRX = 'N'
234: AND ai.wfapproval_status IN ('ACCEPT','APPROVED','MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','ACKNOWLEDGE','CANCEL','CANCELLED'))
235: OR (P_UNAPPROVED_TRX = 'Y' ))
236: UNION ALL

Line 254: FROM ap_invoices ai

250: OR (P_ACCOUNTED = 'BOTH'))
251: UNION ALL
252: SELECT 'A' transaction_type
253: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
254: FROM ap_invoices ai
255: ,ap_invoice_distributions_all aid
256: ,ap_invoices aipre
257: ,ap_invoice_distributions_all aidpre
258: WHERE ai.invoice_id = aid.invoice_id

Line 256: ,ap_invoices aipre

252: SELECT 'A' transaction_type
253: ,SUM((NVL(aid.amount,0)* NVL(ai.exchange_rate,1))*-1) amount_applied
254: FROM ap_invoices ai
255: ,ap_invoice_distributions_all aid
256: ,ap_invoices aipre
257: ,ap_invoice_distributions_all aidpre
258: WHERE ai.invoice_id = aid.invoice_id
259: AND aid.prepay_distribution_id = aidpre.invoice_distribution_id
260: AND aipre.invoice_id = aidpre.invoice_id

Line 267: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)

263: AND ai.vendor_site_id = p_in_vendor_site_id
264: AND ai.invoice_currency_code = NVL2(P_CURRENCY,DECODE(P_CURRENCY,'ANY',ai.invoice_currency_code,P_CURRENCY),ai.invoice_currency_code)
265: AND ai.org_id = p_in_org_id
266: AND ai.wfapproval_status NOT IN ('CANCEL','CANCELLED')
267: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
268: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
269: ,'UNACCOUNTED','N'
270: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
271: AND ((P_UNAPPROVED_TRX = 'N'

Line 270: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))

266: AND ai.wfapproval_status NOT IN ('CANCEL','CANCELLED')
267: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
268: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
269: ,'UNACCOUNTED','N'
270: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
271: AND ((P_UNAPPROVED_TRX = 'N'
272: AND ai.wfapproval_status IN ('ACCEPT','APPROVED','MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','ACKNOWLEDGE'))
273: OR (P_UNAPPROVED_TRX = 'Y' ))
274: );