DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_SALES_ORDERS

Line 1146: FROM MTL_SALES_ORDERS MSO

1142: AND TRANSACTION_STATUS = 3
1143: AND TRANSACTION_SOURCE_TYPE_ID in (2,8)
1144: AND NOT EXISTS (
1145: SELECT NULL
1146: FROM MTL_SALES_ORDERS MSO
1147: WHERE MSO.SALES_ORDER_ID = MMTT.TRANSACTION_SOURCE_ID
1148: AND NVL(START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
1149: AND NVL(END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE
1150: AND ENABLED_FLAG = 'Y');