DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 5234: , mtl_secondary_inventories sub

5230: , msi.lot_control_code
5231: , msi.serial_number_control_code
5232: FROM wms_direct_ship_temp wds
5233: , wms_license_plate_numbers wlpn
5234: , mtl_secondary_inventories sub
5235: , mtl_system_items msi
5236: WHERE wds.GROUP_ID = p_group_id
5237: AND wds.organization_id = p_organization_id
5238: AND wds.dock_door_id = p_dock_door_id

Line 9457: FROM mtl_secondary_inventories sub

9453: -- check if the sub in which lpn resides is reservable or not
9454: BEGIN
9455: SELECT sub.reservable_type
9456: INTO l_sub_reservable_type
9457: FROM mtl_secondary_inventories sub
9458: WHERE sub.secondary_inventory_name = (SELECT subinventory_code
9459: FROM wms_license_plate_numbers
9460: WHERE lpn_id = p_lpn_id)
9461: AND organization_id = p_org_id;