DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_SUBINVENTORIES_VAL_V

Line 2193: ** FROM MTL_SUBINVENTORIES_VAL_V MSVV,

2189: -- commented out by abedajna on 10/12/00 for perf. tuning
2190: /*
2191: ** SELECT 1 into x_dummy FROM dual WHERE exists(
2192: ** SELECT 1
2193: ** FROM MTL_SUBINVENTORIES_VAL_V MSVV,
2194: ** MTL_SYSTEM_ITEMS MSI
2195: ** WHERE MSVV.ORGANIZATION_ID = crec.ORGANIZATION_ID
2196: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2197: ** crec.SUBINVENTORY_CODE

Line 2259: FROM MTL_SUBINVENTORIES_VAL_V MSVV,

2255: -- end 1857638
2256:
2257:
2258: SELECT 1 into x_dummy
2259: FROM MTL_SUBINVENTORIES_VAL_V MSVV,
2260: MTL_SYSTEM_ITEMS MSI
2261: WHERE MSVV.ORGANIZATION_ID = crec.ORGANIZATION_ID
2262: AND MSVV.SECONDARY_INVENTORY_NAME =
2263: crec.SUBINVENTORY_CODE