APPS.INV_PROCESS_TEMP dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 293: FROM ORG_ORGANIZATION_DEFINITIONS OOD

289: AND PROCESS_FLAG = 'Y'
290: AND TRANSACTION_STATUS = 3
291: AND NOT EXISTS (
292: SELECT NULL
293: FROM ORG_ORGANIZATION_DEFINITIONS OOD
294: WHERE OOD.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
295: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
296: if(SQL%FOUND) then return 0; else return 1; end if;
297: END validateFromOrganization;

Line 320: FROM ORG_ORGANIZATION_DEFINITIONS OOD

316: AND PROCESS_FLAG = 'Y'
317: AND TRANSACTION_STATUS = 3
318: AND (NOT EXISTS (
319: SELECT NULL
320: FROM ORG_ORGANIZATION_DEFINITIONS OOD
321: WHERE OOD.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION
322: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE)
323: OR NOT EXISTS (
324: SELECT NULL

Line 1173: ORG_ORGANIZATION_DEFINITIONS OOD

1169: AND TRANSACTION_SOURCE_TYPE_ID = 3
1170: AND NOT EXISTS (
1171: SELECT NULL
1172: FROM GL_CODE_COMBINATIONS GCC,
1173: ORG_ORGANIZATION_DEFINITIONS OOD
1174: WHERE GCC.CODE_COMBINATION_ID = MMTT.TRANSACTION_SOURCE_ID
1175: AND GCC.CHART_OF_ACCOUNTS_ID = OOD.CHART_OF_ACCOUNTS_ID
1176: AND OOD.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1177: AND GCC.ENABLED_FLAG = 'Y'