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'', ''Y'')'; --Included correct validation status , Bug9397505
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', 'Y') --Included correct validation status , Bug9397505
181: AND i.validation_request_id IS NULL

Line 222: FROM ap_invoices ai

218: INTO ln_amount
219: FROM
220: ( SELECT 'I' transaction_type
221: ,SUM(NVL(ai.invoice_amount * NVL(ai.exchange_rate,1),0)) accounted_amount
222: FROM ap_invoices ai
223: WHERE ai.vendor_id = p_in_vendor_id
224: AND ai.vendor_site_id = p_in_vendor_site_id
225: AND ai.invoice_type_lookup_code <> 'PREPAYMENT' --Bug9252303
226: AND ai.gl_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')

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

228: AND ai.org_id = p_in_org_id
229: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y' --'Y' Bug9252303
230: AND P_UNVALIDATED_TRX = 'N')
231: OR P_UNVALIDATED_TRX = 'Y')
232: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
233: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
234: ,'UNACCOUNTED','N'
235: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
236: AND ((P_UNAPPROVED_TRX = 'N'

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

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

Line 258: FROM ap_invoices ai

254: --Bug9252303: Commented below query that selects prepayment applications.
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

Line 260: ,ap_invoices aipre

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
264: AND aipre.invoice_id = aidpre.invoice_id

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

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

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

270: AND ai.wfapproval_status NOT IN ('CANCEL','CANCELLED')
271: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
272: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'
273: ,'UNACCOUNTED','N'
274: ,AP_INVOICES_PKG.get_posting_status(ai.invoice_id))
275: AND ((P_UNAPPROVED_TRX = 'N'
276: AND ai.wfapproval_status IN ('ACCEPT','APPROVED','MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED','ACKNOWLEDGE'))
277: OR (P_UNAPPROVED_TRX = 'Y' ))*/
278: );