DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_SUB_AST_TRK_VAL_V

Line 2204: ** FROM MTL_SUB_AST_TRK_VAL_V MSVV,

2200: ** AND MSI.RESTRICT_SUBINVENTORIES_CODE <> 1
2201: ** AND MSI.INVENTORY_ASSET_FLAG = 'N'
2202: ** UNION
2203: ** SELECT 1
2204: ** FROM MTL_SUB_AST_TRK_VAL_V MSVV,
2205: ** MTL_SYSTEM_ITEMS MSI
2206: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2207: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2208: ** crec.subinventory_code

Line 2270: FROM MTL_SUB_AST_TRK_VAL_V MSVV,

2266: AND MSI.RESTRICT_SUBINVENTORIES_CODE <> 1
2267: AND (MSI.INVENTORY_ASSET_FLAG = 'N' OR x_exp_ast_profile = 1) --bugfix 1857638
2268: UNION ALL
2269: SELECT 1
2270: FROM MTL_SUB_AST_TRK_VAL_V MSVV,
2271: MTL_SYSTEM_ITEMS MSI
2272: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2273: AND MSVV.SECONDARY_INVENTORY_NAME =
2274: crec.subinventory_code