DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on CST_COST_GROUPS

Line 3592: FROM CST_COST_GROUPS CCG

3588: --AND TRANSACTION_SOURCE_TYPE_ID IN (13,15)
3589: AND COST_GROUP_ID IS NOT NULL
3590: AND NOT EXISTS (
3591: SELECT NULL
3592: FROM CST_COST_GROUPS CCG
3593: WHERE CCG.COST_GROUP_ID = MTI.COST_GROUP_ID
3594: AND NVL(CCG.ORGANIZATION_ID, MTI.ORGANIZATION_ID)
3595: =MTI.ORGANIZATION_ID
3596: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE) ) ;

Line 3626: FROM CST_COST_GROUPS CCG

3622: AND PROCESS_FLAG = 1
3623: AND TRANSFER_COST_GROUP_ID IS NOT NULL
3624: AND NOT EXISTS (
3625: SELECT NULL
3626: FROM CST_COST_GROUPS CCG
3627: WHERE CCG.COST_GROUP_ID = MTI.TRANSFER_COST_GROUP_ID
3628: AND NVL(CCG.ORGANIZATION_ID, MTI.ORGANIZATION_ID) =
3629: MTI.ORGANIZATION_ID
3630: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE) ) ;