DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 127: FROM po_line_locations_all po,ap_invoice_lines_all ap

123: AND parent_invoice_line_number IS NULL;
124:
125: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
126: SELECT po.ship_to_organization_id, po.ship_to_location_id
127: FROM po_line_locations_all po,ap_invoice_lines_all ap
128: WHERE po.line_location_id = ap.po_line_location_id
129: AND ap.invoice_id = pr_new.invoice_id
130: AND ap.line_number = pn_line_number;
131: