VIEW: APPS.IGS_FI_SA_SEGMENTS

Source

View Text - Preformatted

SELECT ROWID, SUBACCOUNT_SEGMENT_ID, SUBACCOUNT_ID, SEGMENT, SEGMENT_NUM, SEGMENT_VALUE, ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS_FI_SA_SEGMENTS_ALL WHERE (NVL(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 ROWID
, SUBACCOUNT_SEGMENT_ID
, SUBACCOUNT_ID
, SEGMENT
, SEGMENT_NUM
, SEGMENT_VALUE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_FI_SA_SEGMENTS_ALL
WHERE (NVL(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))