DBA Data[Home] [Help]

APPS.CST_DIAGNOSTICS_PKG dependencies on WIP_ENTITIES

Line 742: FROM WIP_ENTITIES WE

738: WHERE MMT.TRANSACTION_SOURCE_TYPE_ID = 5
739: AND MMT.ORGANIZATION_ID = L_ORGANIZATION_ID
740: AND MMT.COSTED_FLAG = 'E'
741: AND EXISTS (SELECT 1
742: FROM WIP_ENTITIES WE
743: WHERE WE.WIP_ENTITY_ID = MMT.TRANSACTION_SOURCE_ID
744: AND WE.ORGANIZATION_ID = MMT.ORGANIZATION_ID
745: AND WE.ENTITY_TYPE = 5));
746: SELECT 1

Line 749: WIP_ENTITIES WE

745: AND WE.ENTITY_TYPE = 5));
746: SELECT 1
747: INTO L_LOT_FLAG
748: FROM MTL_MATERIAL_TRANSACTIONS MMT,
749: WIP_ENTITIES WE
750: WHERE MMT.TRANSACTION_ID =ITEM_REC.TRANSACTION_ID
751: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
752: AND WE.WIP_ENTITY_ID = MMT.TRANSACTION_SOURCE_ID
753: AND WE.ORGANIZATION_ID = MMT.ORGANIZATION_ID