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.

VIEW: APPS.IGS_EN_NSU_DLSTP

Source

View Text - Preformatted


SELECT nsud.rowid , nsud.non_std_usec_dls_id , nsud.function_name , lkv1.meaning , nsud.definition_code , lkv2.meaning , nsud.org_unit_code , ou.description , nsud.formula_method , nsud.round_method , nsud.offset_dt_code , lkv3.meaning , nsud.offset_duration , nsud.INCL_WKEND_DURATION_FLAG, nsud.created_by , nsud.creation_date , nsud.last_updated_by , nsud.last_update_date , nsud.last_update_login FROM igs_en_nsu_dlstp_all nsud, igs_lookups_view lkv1, igs_lookups_view lkv2, igs_lookups_view lkv3, igs_or_unit ou WHERE (lkv1.lookup_code = nsud.function_name AND lkv1.lookup_type = 'ENROLLMENT_FUNCTION') AND (lkv2.lookup_code = nsud.definition_code AND lkv2.lookup_type = 'DEFINITION_LEVEL') AND (lkv3.lookup_code = nsud.offset_dt_code AND lkv3.lookup_type = 'OFFSET_DATE') AND nsud.org_unit_code = ou.org_unit_cd (+) AND (NVL(nsud.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 NSUD.ROWID
, NSUD.NON_STD_USEC_DLS_ID
, NSUD.FUNCTION_NAME
, LKV1.MEANING
, NSUD.DEFINITION_CODE
, LKV2.MEANING
, NSUD.ORG_UNIT_CODE
, OU.DESCRIPTION
, NSUD.FORMULA_METHOD
, NSUD.ROUND_METHOD
, NSUD.OFFSET_DT_CODE
, LKV3.MEANING
, NSUD.OFFSET_DURATION
, NSUD.INCL_WKEND_DURATION_FLAG
, NSUD.CREATED_BY
, NSUD.CREATION_DATE
, NSUD.LAST_UPDATED_BY
, NSUD.LAST_UPDATE_DATE
, NSUD.LAST_UPDATE_LOGIN
FROM IGS_EN_NSU_DLSTP_ALL NSUD
, IGS_LOOKUPS_VIEW LKV1
, IGS_LOOKUPS_VIEW LKV2
, IGS_LOOKUPS_VIEW LKV3
, IGS_OR_UNIT OU
WHERE (LKV1.LOOKUP_CODE = NSUD.FUNCTION_NAME
AND LKV1.LOOKUP_TYPE = 'ENROLLMENT_FUNCTION')
AND (LKV2.LOOKUP_CODE = NSUD.DEFINITION_CODE
AND LKV2.LOOKUP_TYPE = 'DEFINITION_LEVEL')
AND (LKV3.LOOKUP_CODE = NSUD.OFFSET_DT_CODE
AND LKV3.LOOKUP_TYPE = 'OFFSET_DATE')
AND NSUD.ORG_UNIT_CODE = OU.ORG_UNIT_CD (+)
AND (NVL(NSUD.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) )