eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_TR_ITEM

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.TRACKING_ID TRACKING_ID
, TAB.TRACKING_STATUS TRACKING_STATUS
, TAB.TRACKING_TYPE TRACKING_TYPE
, TAB.SOURCE_PERSON_ID SOURCE_PERSON_ID
, TAB.START_DT START_DT
, TAB.TARGET_DAYS TARGET_DAYS
, TAB.SEQUENCE_IND SEQUENCE_IND
, TAB.BUSINESS_DAYS_IND BUSINESS_DAYS_IND
, TAB.ORIGINATOR_PERSON_ID ORIGINATOR_PERSON_ID
, TAB.S_CREATED_IND S_CREATED_IND
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.COMPLETION_DUE_DT COMPLETION_DUE_DT
, TAB.OVERRIDE_OFFSET_CLC_IND OVERRIDE_OFFSET_CLC_IND
, TAB.PUBLISH_IND PUBLISH_IND
FROM IGS_TR_ITEM_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
ORG_ID
TRACKING_ID
TRACKING_STATUS
TRACKING_TYPE
SOURCE_PERSON_ID
START_DT
TARGET_DAYS
SEQUENCE_IND
BUSINESS_DAYS_IND
ORIGINATOR_PERSON_ID
S_CREATED_IND
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE
PROGRAM_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
COMPLETION_DUE_DT
OVERRIDE_OFFSET_CLC_IND
PUBLISH_IND