DBA Data[Home] [Help]

APPS.AP_PA_API_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 150: FROM po_distributions_ap_v POD, ap_invoice_distributions AID

146: AND invoice_id = X_Invoice_Id;
147:
148: SELECT count(*)
149: INTO accrue_on_receipt_num
150: FROM po_distributions_ap_v POD, ap_invoice_distributions AID
151: WHERE POD.po_distribution_id = AID.po_distribution_id
152: AND AID.invoice_id = X_invoice_id
153: AND POD.accrue_on_receipt_flag = 'Y';
154:

Line 157: FROM po_headers POH, po_distributions_ap_v POD, ap_invoice_distributions AID

153: AND POD.accrue_on_receipt_flag = 'Y';
154:
155: SELECT count(*)
156: INTO closed_po_num
157: FROM po_headers POH, po_distributions_ap_v POD, ap_invoice_distributions AID
158: WHERE POH.po_header_id = POD.po_header_id
159: AND POD.po_distribution_id = AID.po_distribution_id
160: AND AID.invoice_id = X_invoice_id
161: AND POH.closed_code = 'FINALLY CLOSED';

Line 272: WHERE ATC.table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'

268:
269: SELECT ATC.column_name
270: INTO l_column_name
271: FROM sys.all_tab_columns ATC
272: WHERE ATC.table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
273: AND ATC.column_name = 'AMOUNT_VARIANCE';
274:
275: EXCEPTION
276: --One of reasons control is here is due to NO_DATA_FOUND exception,

Line 291: FROM ap_invoice_distributions_all

287: IF (l_column_name IS NOT NULL) THEN
288: */
289: l_statement :=
290: 'SELECT NVL(amount_variance,0), NVL(base_amount_variance,0)
291: FROM ap_invoice_distributions_all
292: WHERE invoice_id ='|| p_invoice_id ||
293: 'AND invoice_distribution_id ='|| p_invoice_distribution_id ;
294:
295: EXECUTE IMMEDIATE l_statement INTO p_amount_variance,