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: APPS.IGS_TR_ITEM

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)