VIEW: APPS.AP_SEC_V

Source

View Text - Preformatted

SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) ORG_ID FROM DUAL UNION SELECT ORGANIZATION_ID ORG_ID FROM PER_ORGANIZATION_LIST WHERE SECURITY_PROFILE_ID = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')

View Text - HTML Formatted

SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) ORG_ID
FROM DUAL UNION SELECT ORGANIZATION_ID ORG_ID
FROM PER_ORGANIZATION_LIST
WHERE SECURITY_PROFILE_ID = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')