eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_TP_STMT_PKG dependencies on AP_INVOICES_PKG

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 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: );