DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1267: FROM mtl_secondary_inventories

1263: l_lot_status NUMBER;
1264:
1265: CURSOR c_sub_status IS
1266: SELECT status_id
1267: FROM mtl_secondary_inventories
1268: WHERE organization_id = p_organization_id
1269: AND secondary_inventory_name = p_subinventory_code;
1270:
1271: CURSOR c_loc_status IS

Line 1592: ,mtl_secondary_inventories sub

1588: ,moq.cost_group_id
1589: ,moq.project_id
1590: ,moq.task_id
1591: ) x
1592: ,mtl_secondary_inventories sub
1593: ,mtl_lot_numbers lot
1594: WHERE
1595: x.primary_quantity > 0
1596: AND x.organization_id = sub.organization_id

Line 4134: FROM mtl_secondary_inventories

4130: , p_subinventory_code in varchar2
4131: )
4132: IS
4133: SELECT decode(reservable_type,2,0,reservable_type)
4134: FROM mtl_secondary_inventories
4135: WHERE organization_id = p_organization_id
4136: AND secondary_inventory_name = p_subinventory_code;
4137:
4138: CURSOR c_loc_status (p_organization_id in NUMBER