Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_MAPPING_COMP_USAGES_V |
SELECT MCU.ROWID ROW_ID
, MCU.MAPPING_COMP_USAGE_ID
, MCU.MAPPING_ID
, MCU.MAPPING_COMPONENT_ID
, MPC.NAME
, MPC.FIELD_NAME
, MPC.BUILDING_BLOCK_CATEGORY
, MPC.BLD_BLK_INFO_TYPE
, MPC.SEGMENT
, MPC.END_USER_COLUMN_NAME
, MCU.OBJECT_VERSION_NUMBER
, MCU.CREATED_BY
, MCU.CREATION_DATE
, MCU.LAST_UPDATED_BY
, MCU.LAST_UPDATE_DATE
, MCU.LAST_UPDATE_LOGIN
FROM HXC_MAPPING_COMPONENTS_V MPC
, HXC_MAPPING_COMP_USAGES MCU
WHERE MPC.MAPPING_COMPONENT_ID = MCU.MAPPING_COMPONENT_ID ORDER BY MPC.NAME
, MPC.FIELD_NAME