APPS.WSH_SC_TRX_INTERFACE dependencies on MTL_ITEM_LOCATIONS

Line 438: FROM MTL_ITEM_LOCATIONS

434: = ( SELECT Segment1, Segment2, Segment3, Segment4, Segment5,
435: Segment6, Segment7, Segment8, Segment9, Segment10,
436: Segment11, Segment12, Segment13, Segment14, Segment15,
437: Segment16, Segment17, Segment18, Segment19, Segment20
438: FROM MTL_ITEM_LOCATIONS
439: WHERE inventory_location_id = nvl(x_locator_id,pld.inventory_location_id))
440: WHERE pld.picking_line_id = X_picking_line_id
441: and pld.picking_line_detail_id = nvl(X_picking_line_detail_id, pld.picking_line_detail_id)
442: and ( (nvl(serial_number,nvl(x_sn,'~')) = nvl(X_sn,'~') and requested_quantity = x_shipped_quantity)

Line 633: MTL_ITEM_LOCATIONS M

629: x_delivery_id,
630: x_container_id,
631: NULL
632: FROM SO_PICKING_LINE_DETAILS PLD,
633: MTL_ITEM_LOCATIONS M
634: WHERE PLD.PICKING_LINE_DETAIL_ID = X_Parent_Detail_Id
635: AND m.inventory_location_id (+) = nvl(x_locator_id,pld.inventory_location_id);
636:
637: EXCEPTION when others then