DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on CST_COST_GROUPS

Line 3779: FROM CST_COST_GROUPS CCG

3775: --AND TRANSACTION_SOURCE_TYPE_ID IN (13,15)
3776: AND COST_GROUP_ID IS NOT NULL
3777: AND NOT EXISTS (
3778: SELECT NULL
3779: FROM CST_COST_GROUPS CCG
3780: WHERE CCG.COST_GROUP_ID = MTI.COST_GROUP_ID
3781: AND NVL(CCG.ORGANIZATION_ID, MTI.ORGANIZATION_ID)
3782: =MTI.ORGANIZATION_ID
3783: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE) ) ;

Line 3813: FROM CST_COST_GROUPS CCG

3809: AND PROCESS_FLAG = 1
3810: AND TRANSFER_COST_GROUP_ID IS NOT NULL
3811: AND NOT EXISTS (
3812: SELECT NULL
3813: FROM CST_COST_GROUPS CCG
3814: WHERE CCG.COST_GROUP_ID = MTI.TRANSFER_COST_GROUP_ID
3815: AND NVL(CCG.ORGANIZATION_ID, MTI.ORGANIZATION_ID) =
3816: MTI.ORGANIZATION_ID
3817: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE) ) ;