DBA Data[Home] [Help]

APPS.OPIMPXWI dependencies on MTL_SECONDARY_INVENTORIES

Line 1643: FROM mtl_secondary_inventories sub

1639:
1640: IF p_subinventory IS NOT NULL THEN
1641: SELECT asset_inventory
1642: INTO asset_sub
1643: FROM mtl_secondary_inventories sub
1644: WHERE sub.SECONDARY_INVENTORY_NAME=p_subinventory
1645: AND sub.organization_id = p_organization_id;
1646:
1647: if (asset_sub<>1) then

Line 2181: FROM mtl_secondary_inventories sub

2177:
2178: IF l_subinventory IS NOT NULL THEN
2179: SELECT asset_inventory
2180: INTO asset_sub
2181: FROM mtl_secondary_inventories sub
2182: WHERE sub.SECONDARY_INVENTORY_NAME=l_subinventory
2183: AND sub.organization_id = Org_id;
2184:
2185: if (asset_sub<>1) then