DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_GENERIC_DISPOSITIONS

Line 1199: FROM MTL_GENERIC_DISPOSITIONS MGD

1195: AND TRANSACTION_STATUS = 3
1196: AND TRANSACTION_SOURCE_TYPE_ID = 6
1197: AND NOT EXISTS (
1198: SELECT NULL
1199: FROM MTL_GENERIC_DISPOSITIONS MGD
1200: WHERE MGD.DISPOSITION_ID = MMTT.TRANSACTION_SOURCE_ID
1201: AND MGD.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1202: AND MGD.ENABLED_FLAG = 'Y'
1203: AND NVL(MGD.START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE