DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on MTL_ITEM_SUB_AST_TRK_VAL_V

Line 2215: ** FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,

2211: ** AND MSI.RESTRICT_SUBINVENTORIES_CODE <> 1
2212: ** AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2213: ** UNION
2214: ** SELECT 1
2215: ** FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,
2216: ** MTL_SYSTEM_ITEMS MSI
2217: ** WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2218: ** AND MSVV.SECONDARY_INVENTORY_NAME =
2219: ** crec.subinventory_code

Line 2281: FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,

2277: AND MSI.RESTRICT_SUBINVENTORIES_CODE <> 1
2278: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
2279: UNION ALL
2280: SELECT 1
2281: FROM MTL_ITEM_SUB_AST_TRK_VAL_V MSVV,
2282: MTL_SYSTEM_ITEMS MSI
2283: WHERE MSVV.ORGANIZATION_ID = crec.orgANIZATION_ID
2284: AND MSVV.SECONDARY_INVENTORY_NAME =
2285: crec.subinventory_code