DBA Data[Home] [Help]

APPS.RCV_824_SV dependencies on PO_LINES

Line 42: mtl_system_items_kfv msi, po_headers poh, po_lines pol

38: CURSOR get_receipt_line_rows IS
39: SELECT msi.concatenated_segments, poh.segment1, pol.line_num, rsl.bar_code_label,
40: error_message, error_message_name
41: FROM po_interface_errors pie, rcv_shipment_lines rsl ,
42: mtl_system_items_kfv msi, po_headers poh, po_lines pol
43: WHERE pol.po_line_id = rsl.po_line_id
44: AND poh.po_header_id = rsl.po_header_id
45: AND msi.inventory_item_id (+)= rsl.item_id
46: AND NVL(msi.organization_id, rsl.to_organization_id) = rsl.to_organization_id