DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1273: FROM mtl_item_locations

1269: AND secondary_inventory_name = p_subinventory_code;
1270:
1271: CURSOR c_loc_status IS
1272: SELECT status_id
1273: FROM mtl_item_locations
1274: WHERE organization_id = p_organization_id
1275: AND inventory_location_id = p_locator_id;
1276:
1277: CURSOR c_lot_status IS

Line 4143: FROM mtl_item_locations

4139: , p_locator_id in NUMBER
4140: )
4141: IS
4142: SELECT decode(reservable_type,2,0,reservable_type)
4143: FROM mtl_item_locations
4144: WHERE organization_id = p_organization_id
4145: AND inventory_location_id = p_locator_id;
4146:
4147: CURSOR c_lot_status (p_organization_id in NUMBER