VIEW: APPS.HR_DE_ORG_LINK_TYPES_MAPPING

Source

View Text - Preformatted

SELECT uci1.value, uci2.value FROM pay_user_tables ut, pay_user_rows_f ur, pay_user_columns uc1, pay_user_columns uc2, pay_user_column_instances_f uci1, pay_user_column_instances_f uci2 WHERE ut.user_table_name = 'HR_DE_LINK_TYPE_MAPPINGS' AND ur.user_table_id = ut.user_table_id AND uc1.user_table_id = ut.user_table_id AND uc1.user_column_name = 'ORG_LINK_TYPE' AND uc2.user_table_id = ut.user_table_id AND uc2.user_column_name = 'ORG_CLASS' AND uci1.user_row_id = ur.user_row_id AND uci1.user_column_id = uc1.user_column_id AND uci2.user_row_id = ur.user_row_id AND uci2.user_column_id = uc2.user_column_id

View Text - HTML Formatted

SELECT UCI1.VALUE
, UCI2.VALUE
FROM PAY_USER_TABLES UT
, PAY_USER_ROWS_F UR
, PAY_USER_COLUMNS UC1
, PAY_USER_COLUMNS UC2
, PAY_USER_COLUMN_INSTANCES_F UCI1
, PAY_USER_COLUMN_INSTANCES_F UCI2
WHERE UT.USER_TABLE_NAME = 'HR_DE_LINK_TYPE_MAPPINGS'
AND UR.USER_TABLE_ID = UT.USER_TABLE_ID
AND UC1.USER_TABLE_ID = UT.USER_TABLE_ID
AND UC1.USER_COLUMN_NAME = 'ORG_LINK_TYPE'
AND UC2.USER_TABLE_ID = UT.USER_TABLE_ID
AND UC2.USER_COLUMN_NAME = 'ORG_CLASS'
AND UCI1.USER_ROW_ID = UR.USER_ROW_ID
AND UCI1.USER_COLUMN_ID = UC1.USER_COLUMN_ID
AND UCI2.USER_ROW_ID = UR.USER_ROW_ID
AND UCI2.USER_COLUMN_ID = UC2.USER_COLUMN_ID