DBA Data[Home] [Help]

APPS.AP_PA_API_PKG dependencies on PO_HEADERS

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';