View: HR_DE_ORG_LINK_TYPES_MAPPING

Product:	PER - Human Resources
Description:	View on User table structure for mapping German Org_classes to Org_link_types
Implementation/DBA Data:	APPS.HR_DE_ORG_LINK_TYPES_MAPPING

View Text

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

Columns