DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 4956: , mtl_secondary_inventories sub

4952: , msi.lot_control_code
4953: , msi.serial_number_control_code
4954: FROM wms_direct_ship_temp wds
4955: , wms_license_plate_numbers wlpn
4956: , mtl_secondary_inventories sub
4957: , mtl_system_items msi
4958: WHERE wds.GROUP_ID = p_group_id
4959: AND wds.organization_id = p_organization_id
4960: AND wds.dock_door_id = p_dock_door_id

Line 8331: FROM mtl_secondary_inventories sub

8327: -- check if the sub in which lpn resides is reservable or not
8328: BEGIN
8329: SELECT sub.reservable_type
8330: INTO l_sub_reservable_type
8331: FROM mtl_secondary_inventories sub
8332: WHERE sub.secondary_inventory_name = (SELECT subinventory_code
8333: FROM wms_license_plate_numbers
8334: WHERE lpn_id = p_lpn_id)
8335: AND organization_id = p_org_id;