VIEW: APPS.PAY_USER_COLUMN_INSTANCES_FV

Source

View Text - Preformatted

SELECT pci.rowid row_id , pci.user_column_instance_id , pci.effective_start_date , pci.effective_end_date , pci.user_row_id , pci.user_column_id , pci.business_group_id + 0 business_group_id , pci.legislation_code , pci.legislation_subgroup , pur.row_low_range_or_name , urt.row_low_range_or_name , pur.row_high_range , pci.value , pur.display_sequence , pci.last_update_date , pci.last_updated_by , pci.last_update_login , pci.created_by , pci.creation_date , pci.object_version_number FROM pay_user_column_instances_f pci, pay_user_rows_f pur, pay_user_rows_f_tl urt WHERE pci.user_row_id = pur.user_row_id AND pci.user_row_id = urt.user_row_id AND urt.language = userenv('lang') AND pci.effective_start_date <=(select effective_date FROM fnd_sessions WHERE session_id = userenv('sessionid') ) AND pci.effective_end_date >=(select effective_date FROM fnd_sessions WHERE session_id = userenv('sessionid') ) AND pur.effective_start_date <=(select effective_date FROM fnd_sessions WHERE session_id = userenv('sessionid') ) AND pur.effective_end_date >=(select effective_date FROM fnd_sessions WHERE session_id = userenv('sessionid') )

View Text - HTML Formatted

SELECT PCI.ROWID ROW_ID
, PCI.USER_COLUMN_INSTANCE_ID
, PCI.EFFECTIVE_START_DATE
, PCI.EFFECTIVE_END_DATE
, PCI.USER_ROW_ID
, PCI.USER_COLUMN_ID
, PCI.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PCI.LEGISLATION_CODE
, PCI.LEGISLATION_SUBGROUP
, PUR.ROW_LOW_RANGE_OR_NAME
, URT.ROW_LOW_RANGE_OR_NAME
, PUR.ROW_HIGH_RANGE
, PCI.VALUE
, PUR.DISPLAY_SEQUENCE
, PCI.LAST_UPDATE_DATE
, PCI.LAST_UPDATED_BY
, PCI.LAST_UPDATE_LOGIN
, PCI.CREATED_BY
, PCI.CREATION_DATE
, PCI.OBJECT_VERSION_NUMBER
FROM PAY_USER_COLUMN_INSTANCES_F PCI
, PAY_USER_ROWS_F PUR
, PAY_USER_ROWS_F_TL URT
WHERE PCI.USER_ROW_ID = PUR.USER_ROW_ID
AND PCI.USER_ROW_ID = URT.USER_ROW_ID
AND URT.LANGUAGE = USERENV('LANG')
AND PCI.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PCI.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PUR.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PUR.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )