DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on MTL_SUPPLY

Line 946: , mtl_supply ms

942: , rsl.item_description
943: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
944: FROM rcv_shipment_lines rsl
945: , rcv_shipment_headers rsh
946: , mtl_supply ms
947: WHERE rsl.shipment_header_id = v_shipment_header_id
948: AND rsh.shipment_header_id = rsl.shipment_header_id
949: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
950: AND rsl.item_id = v_item_id

Line 1042: , mtl_supply ms

1038: IS
1039: SELECT COUNT(*)
1040: FROM rcv_shipment_lines rsl
1041: , rcv_shipment_headers rsh
1042: , mtl_supply ms
1043: WHERE rsl.shipment_header_id = v_shipment_header_id
1044: AND rsh.shipment_header_id = rsl.shipment_header_id
1045: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
1046: AND rsl.item_id = v_item_id