Product: | JTF - CRM Foundation |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JTF_IH_ACTIVE_WRAP_UPS_VL |
SELECT ROWID
, WRAP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OUTCOME_REQUIRED
, RESULT_REQUIRED
, REASON_REQUIRED
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, ACTION_ACTIVITY_ID
, OBJECT_ID
, OBJECT_TYPE
, SOURCE_CODE_ID
, SOURCE_CODE
, SECURITY_GROUP_ID
, START_DATE
, END_DATE
FROM JTF_IH_WRAP_UPS
WHERE START_DATE <= SYSDATE+1
AND DECODE(TO_CHAR(END_DATE
, 'MM/DD/RRRR')
, '01/01/4721'
, SYSDATE+1
, NULL
, SYSDATE+1
, END_DATE) >= SYSDATE+1