DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1140: FROM mtl_item_locations

1136: AND secondary_inventory_name = p_subinventory_code;
1137:
1138: CURSOR c_loc_status IS
1139: SELECT status_id
1140: FROM mtl_item_locations
1141: WHERE organization_id = p_organization_id
1142: AND inventory_location_id = p_locator_id;
1143:
1144: CURSOR c_lot_status IS

Line 3724: FROM mtl_item_locations

3720: , p_locator_id in NUMBER
3721: )
3722: IS
3723: SELECT decode(reservable_type,2,0,reservable_type)
3724: FROM mtl_item_locations
3725: WHERE organization_id = p_organization_id
3726: AND inventory_location_id = p_locator_id;
3727:
3728: CURSOR c_lot_status (p_organization_id in NUMBER