DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on MTL_SUPPLY

Line 869: , mtl_supply ms

865: , rsl.item_description
866: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
867: FROM rcv_shipment_lines rsl
868: , rcv_shipment_headers rsh
869: , mtl_supply ms
870: WHERE rsl.shipment_header_id = v_shipment_header_id
871: AND rsh.shipment_header_id = rsl.shipment_header_id
872: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
873: AND rsl.item_id = v_item_id

Line 917: , mtl_supply ms

913: IS
914: SELECT COUNT(*)
915: FROM rcv_shipment_lines rsl
916: , rcv_shipment_headers rsh
917: , mtl_supply ms
918: WHERE rsl.shipment_header_id = v_shipment_header_id
919: AND rsh.shipment_header_id = rsl.shipment_header_id
920: AND rsl.shipment_line_id = Nvl(v_shipment_line_id, rsl.shipment_line_id)
921: AND rsl.item_id = v_item_id