DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1134: FROM mtl_secondary_inventories

1130: l_lot_status NUMBER;
1131:
1132: CURSOR c_sub_status IS
1133: SELECT status_id
1134: FROM mtl_secondary_inventories
1135: WHERE organization_id = p_organization_id
1136: AND secondary_inventory_name = p_subinventory_code;
1137:
1138: CURSOR c_loc_status IS

Line 1459: ,mtl_secondary_inventories sub

1455: ,moq.cost_group_id
1456: ,moq.project_id
1457: ,moq.task_id
1458: ) x
1459: ,mtl_secondary_inventories sub
1460: ,mtl_lot_numbers lot
1461: WHERE
1462: x.primary_quantity > 0
1463: AND x.organization_id = sub.organization_id

Line 3715: FROM mtl_secondary_inventories

3711: , p_subinventory_code in varchar2
3712: )
3713: IS
3714: SELECT decode(reservable_type,2,0,reservable_type)
3715: FROM mtl_secondary_inventories
3716: WHERE organization_id = p_organization_id
3717: AND secondary_inventory_name = p_subinventory_code;
3718:
3719: CURSOR c_loc_status (p_organization_id in NUMBER