VIEW: APPS.PAY_USER_COLUMNS_V

Source

View Text - Preformatted

SELECT PUC.ROWID ROW_ID , PUC.USER_COLUMN_ID , PUC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , PUC.LEGISLATION_CODE , PUC.USER_TABLE_ID , PUC.USER_COLUMN_NAME , PUC.FORMULA_ID , FF.FORMULA_NAME , PUC.LEGISLATION_SUBGROUP , PUC.LAST_UPDATE_DATE , PUC.LAST_UPDATED_BY , PUC.LAST_UPDATE_LOGIN , PUC.CREATED_BY , PUC.CREATION_DATE FROM PAY_USER_COLUMNS PUC, FF_FORMULAS_F FF WHERE PUC.FORMULA_ID = FF.FORMULA_ID (+) AND ( PUC.FORMULA_ID IS NULL OR ( FF.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE FROM FND_SESSIONS WHERE SESSION_ID = USERENV('sessionid') ) AND FF.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE FROM FND_SESSIONS WHERE SESSION_ID = USERENV('sessionid') ) ) )

View Text - HTML Formatted

SELECT PUC.ROWID ROW_ID
, PUC.USER_COLUMN_ID
, PUC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PUC.LEGISLATION_CODE
, PUC.USER_TABLE_ID
, PUC.USER_COLUMN_NAME
, PUC.FORMULA_ID
, FF.FORMULA_NAME
, PUC.LEGISLATION_SUBGROUP
, PUC.LAST_UPDATE_DATE
, PUC.LAST_UPDATED_BY
, PUC.LAST_UPDATE_LOGIN
, PUC.CREATED_BY
, PUC.CREATION_DATE
FROM PAY_USER_COLUMNS PUC
, FF_FORMULAS_F FF
WHERE PUC.FORMULA_ID = FF.FORMULA_ID (+)
AND ( PUC.FORMULA_ID IS NULL OR ( FF.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND FF.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') ) ) )