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
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