DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on PO_VENDORS

Line 6536: from mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha, po_vendors pv

6532: x_msg_data := ' ';
6533:
6534: select distinct pha.po_header_id, pha.segment1, pv.vendor_id, pv.vendor_name, plla.po_line_id
6535: into x_po_id, x_po_number, x_vendor_id, x_vendor_name, v_po_line_id
6536: from mtl_txn_request_lines mtrl, po_line_locations_all plla, po_headers_all pha, po_vendors pv
6537: where reference = 'PO_LINE_LOCATION_ID'
6538: and mtrl.reference_id = plla.line_location_id
6539: and plla.po_header_id = pha.po_header_id
6540: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)