DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on GL_CODE_COMBINATIONS

Line 2673: FROM GL_CODE_COMBINATIONS GCC,

2669: AND PROCESS_FLAG = 1
2670: AND TRANSACTION_SOURCE_TYPE_ID = 3
2671: AND NOT EXISTS (
2672: SELECT NULL
2673: FROM GL_CODE_COMBINATIONS GCC,
2674: ORG_ORGANIZATION_DEFINITIONS OOD
2675: WHERE GCC.CODE_COMBINATION_ID = MTI.TRANSACTION_SOURCE_ID
2676: AND GCC.CHART_OF_ACCOUNTS_ID = OOD.CHART_OF_ACCOUNTS_ID
2677: AND OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 3226: FROM GL_CODE_COMBINATIONS GCC

3222: AND PROCESS_FLAG = 1
3223: AND DISTRIBUTION_ACCOUNT_ID IS NOT NULL
3224: AND NOT EXISTS (
3225: SELECT NULL
3226: FROM GL_CODE_COMBINATIONS GCC
3227: WHERE GCC.CODE_COMBINATION_ID = MTI.DISTRIBUTION_ACCOUNT_ID
3228: AND GCC.CHART_OF_ACCOUNTS_ID
3229: = (SELECT CHART_OF_ACCOUNTS_ID
3230: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7180: FROM GL_CODE_COMBINATIONS GCC

7176: AND PROCESS_FLAG = 1
7177: AND MATERIAL_ACCOUNT IS NOT NULL
7178: AND NOT EXISTS (
7179: SELECT NULL
7180: FROM GL_CODE_COMBINATIONS GCC
7181: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_ACCOUNT
7182: AND GCC.CHART_OF_ACCOUNTS_ID
7183: = (SELECT CHART_OF_ACCOUNTS_ID
7184: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7228: FROM GL_CODE_COMBINATIONS GCC

7224: AND PROCESS_FLAG = 1
7225: AND MATERIAL_OVERHEAD_ACCOUNT IS NOT NULL
7226: AND NOT EXISTS (
7227: SELECT NULL
7228: FROM GL_CODE_COMBINATIONS GCC
7229: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_OVERHEAD_ACCOUNT
7230: AND GCC.CHART_OF_ACCOUNTS_ID
7231: = (SELECT CHART_OF_ACCOUNTS_ID
7232: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7275: FROM GL_CODE_COMBINATIONS GCC

7271: AND PROCESS_FLAG = 1
7272: AND RESOURCE_ACCOUNT IS NOT NULL
7273: AND NOT EXISTS (
7274: SELECT NULL
7275: FROM GL_CODE_COMBINATIONS GCC
7276: WHERE GCC.CODE_COMBINATION_ID = MTI.RESOURCE_ACCOUNT
7277: AND GCC.CHART_OF_ACCOUNTS_ID
7278: = (SELECT CHART_OF_ACCOUNTS_ID
7279: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7322: FROM GL_CODE_COMBINATIONS GCC

7318: AND PROCESS_FLAG = 1
7319: AND OUTSIDE_PROCESSING_ACCOUNT IS NOT NULL
7320: AND NOT EXISTS (
7321: SELECT NULL
7322: FROM GL_CODE_COMBINATIONS GCC
7323: WHERE GCC.CODE_COMBINATION_ID = MTI.OUTSIDE_PROCESSING_ACCOUNT
7324: AND GCC.CHART_OF_ACCOUNTS_ID
7325: = (SELECT CHART_OF_ACCOUNTS_ID
7326: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7369: FROM GL_CODE_COMBINATIONS GCC

7365: AND PROCESS_FLAG = 1
7366: AND OVERHEAD_ACCOUNT IS NOT NULL
7367: AND NOT EXISTS (
7368: SELECT NULL
7369: FROM GL_CODE_COMBINATIONS GCC
7370: WHERE GCC.CODE_COMBINATION_ID = MTI.OVERHEAD_ACCOUNT
7371: AND GCC.CHART_OF_ACCOUNTS_ID
7372: = (SELECT CHART_OF_ACCOUNTS_ID
7373: FROM ORG_ORGANIZATION_DEFINITIONS OOD

Line 7433: FROM GL_CODE_COMBINATIONS GCC

7429: AND PROCESS_FLAG = 1
7430: AND MATERIAL_EXPENSE_ACCOUNT IS NOT NULL
7431: AND NOT EXISTS (
7432: SELECT NULL
7433: FROM GL_CODE_COMBINATIONS GCC
7434: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_EXPENSE_ACCOUNT
7435: AND GCC.CHART_OF_ACCOUNTS_ID =
7436: (SELECT CHART_OF_ACCOUNTS_ID
7437: FROM ORG_ORGANIZATION_DEFINITIONS OOD