DBA Data[Home] [Help]

VIEW: APPS.PAY_USER_ROWS_D

Source

View Text - Preformatted

SELECT UR.USER_ROW_ID , UR.EFFECTIVE_START_DATE , UR.EFFECTIVE_END_DATE , UR.ROW_LOW_RANGE_OR_NAME , UR.ROW_HIGH_RANGE , UR.DISPLAY_SEQUENCE , UR.LAST_UPDATE_DATE , FU.USER_NAME FROM PAY_USER_ROWS_F UR , FND_USER FU WHERE FU.USER_ID (+)= UR.LAST_UPDATED_BY
View Text - HTML Formatted

SELECT UR.USER_ROW_ID
, UR.EFFECTIVE_START_DATE
, UR.EFFECTIVE_END_DATE
, UR.ROW_LOW_RANGE_OR_NAME
, UR.ROW_HIGH_RANGE
, UR.DISPLAY_SEQUENCE
, UR.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PAY_USER_ROWS_F UR
, FND_USER FU
WHERE FU.USER_ID (+)= UR.LAST_UPDATED_BY