DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_ITEM_SUB_VAL_V

Line 2227: ** FROM MTL_ITEM_SUB_VAL_V MSVV,

2223: ** AND MSI.organization_id = crec.organization_id
2224: ** AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2225: ** UNION
2226: ** SELECT 1
2227: ** FROM MTL_ITEM_SUB_VAL_V MSVV,
2228: ** MTL_SYSTEM_ITEMS MSI
2229: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2230: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2231: ** crec.subinventory_code

Line 2293: FROM MTL_ITEM_SUB_VAL_V MSVV,

2289: AND MSI.organization_id = crec.organization_id
2290: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2291: UNION ALL
2292: SELECT 1
2293: FROM MTL_ITEM_SUB_VAL_V MSVV,
2294: MTL_SYSTEM_ITEMS MSI
2295: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2296: AND MSVV.SECONDARY_INVENTORY_NAME =
2297: crec.subinventory_code