DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on PO_HEADERS_ALL

Line 632: po_headers_all poh

628: api.invoice_date
629: FROM ap_invoices_all api,
630: ap_invoice_distributions_all apd,
631: po_distributions_all pod,
632: po_headers_all poh
633: WHERE apd.invoice_id = api.invoice_id
634: AND pod.po_header_id = poh.po_header_id
635: AND apd.po_distribution_id = pod.po_distribution_id
636: AND apd.invoice_line_number = pr_ap_inv_line_item.line_number

Line 3104: FROM Po_Headers_All

3100: CURSOR fetch_inv_org_id_cur(c_po_dist_id NUMBER) IS
3101: SELECT Inventory_Organization_Id
3102: FROM Hr_Locations
3103: WHERE Location_Id = ( SELECT Ship_To_Location_Id
3104: FROM Po_Headers_All
3105: WHERE Po_Header_Id = ( SELECT Po_Header_Id
3106: FROM Po_Distributions_All
3107: WHERE Po_Distribution_Id = c_po_dist_id
3108: )