DBA Data[Home] [Help]

APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_BATCHES_ALL

Line 38: ap_batches_all AB,

34: VS.invoice_amount_limit,
35: SP.base_currency_code,
36: nvl(VS.hold_future_payments_flag,'N')
37: from ap_invoices_all AI,
38: ap_batches_all AB,
39: ap_system_parameters_all SP,
40: po_vendor_sites VS
41: where AI.invoice_id = X_invoice_id
42: and AI.batch_id = AB.batch_id (+)

Line 220: ap_batches_all AB --Bug8409056

216: AB.hold_lookup_code,
217: AB.hold_reason,
218: AI.invoice_date
219: from ap_invoices AI,
220: ap_batches_all AB --Bug8409056
221: where AI.invoice_id = X_invoice_id
222: and AI.batch_id = AB.batch_id (+);
223:
224: BEGIN

Line 810: ap_batches_all AB --Bug: 6668692 : Added _all to table name

806: '',null,
807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
808: AB.BATCH_ID))
809: from ap_invoices AI,
810: ap_batches_all AB --Bug: 6668692 : Added _all to table name
811: where AI.invoice_id = X_invoice_id
812: and AI.batch_id = AB.batch_id (+);
813: BEGIN
814: