DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on GL_CODE_COMBINATIONS

Line 2820: FROM GL_CODE_COMBINATIONS GCC,

2816: AND PROCESS_FLAG = 1
2817: AND TRANSACTION_SOURCE_TYPE_ID = 3
2818: AND NOT EXISTS (
2819: SELECT NULL
2820: FROM GL_CODE_COMBINATIONS GCC,
2821: ORG_ORGANIZATION_DEFINITIONS OOD
2822: WHERE GCC.CODE_COMBINATION_ID = MTI.TRANSACTION_SOURCE_ID
2823: AND GCC.CHART_OF_ACCOUNTS_ID = OOD.CHART_OF_ACCOUNTS_ID
2824: AND OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 3413: FROM GL_CODE_COMBINATIONS GCC

3409: AND PROCESS_FLAG = 1
3410: AND DISTRIBUTION_ACCOUNT_ID IS NOT NULL
3411: AND NOT EXISTS (
3412: SELECT NULL
3413: FROM GL_CODE_COMBINATIONS GCC
3414: WHERE GCC.CODE_COMBINATION_ID = MTI.DISTRIBUTION_ACCOUNT_ID
3415: AND GCC.CHART_OF_ACCOUNTS_ID
3416: = (SELECT CHART_OF_ACCOUNTS_ID
3417: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7695: FROM GL_CODE_COMBINATIONS GCC

7691: AND PROCESS_FLAG = 1
7692: AND MATERIAL_ACCOUNT IS NOT NULL
7693: AND NOT EXISTS (
7694: SELECT NULL
7695: FROM GL_CODE_COMBINATIONS GCC
7696: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_ACCOUNT
7697: AND GCC.CHART_OF_ACCOUNTS_ID
7698: = (SELECT CHART_OF_ACCOUNTS_ID
7699: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7743: FROM GL_CODE_COMBINATIONS GCC

7739: AND PROCESS_FLAG = 1
7740: AND MATERIAL_OVERHEAD_ACCOUNT IS NOT NULL
7741: AND NOT EXISTS (
7742: SELECT NULL
7743: FROM GL_CODE_COMBINATIONS GCC
7744: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_OVERHEAD_ACCOUNT
7745: AND GCC.CHART_OF_ACCOUNTS_ID
7746: = (SELECT CHART_OF_ACCOUNTS_ID
7747: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7790: FROM GL_CODE_COMBINATIONS GCC

7786: AND PROCESS_FLAG = 1
7787: AND RESOURCE_ACCOUNT IS NOT NULL
7788: AND NOT EXISTS (
7789: SELECT NULL
7790: FROM GL_CODE_COMBINATIONS GCC
7791: WHERE GCC.CODE_COMBINATION_ID = MTI.RESOURCE_ACCOUNT
7792: AND GCC.CHART_OF_ACCOUNTS_ID
7793: = (SELECT CHART_OF_ACCOUNTS_ID
7794: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7837: FROM GL_CODE_COMBINATIONS GCC

7833: AND PROCESS_FLAG = 1
7834: AND OUTSIDE_PROCESSING_ACCOUNT IS NOT NULL
7835: AND NOT EXISTS (
7836: SELECT NULL
7837: FROM GL_CODE_COMBINATIONS GCC
7838: WHERE GCC.CODE_COMBINATION_ID = MTI.OUTSIDE_PROCESSING_ACCOUNT
7839: AND GCC.CHART_OF_ACCOUNTS_ID
7840: = (SELECT CHART_OF_ACCOUNTS_ID
7841: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7884: FROM GL_CODE_COMBINATIONS GCC

7880: AND PROCESS_FLAG = 1
7881: AND OVERHEAD_ACCOUNT IS NOT NULL
7882: AND NOT EXISTS (
7883: SELECT NULL
7884: FROM GL_CODE_COMBINATIONS GCC
7885: WHERE GCC.CODE_COMBINATION_ID = MTI.OVERHEAD_ACCOUNT
7886: AND GCC.CHART_OF_ACCOUNTS_ID
7887: = (SELECT CHART_OF_ACCOUNTS_ID
7888: FROM ORG_ORGANIZATION_DEFINITIONS OOD