VIEW: APPS.PAY_RETRO_COMPONENT_USAGES_V

Source

View Text - Preformatted

SELECT prcu.rowid row_id , prcu.retro_component_usage_id , prcu.business_group_id , prcu.legislation_code , prcu.retro_component_id , ptr.component_name , prcu.creator_id , prcu.creator_type , prcu.default_component , prcu.reprocess_type , hl.meaning d_reprocess_type , prcu.object_version_number , prcu.creation_date , prcu.created_by , prcu.last_update_date , prcu.last_updated_by , prcu.last_update_login , prcu.replace_run_flag, prcu.use_override_dates from pay_retro_component_usages prcu , pay_retro_components ptr , hr_lookups hl WHERE ptr.retro_component_id = prcu.retro_component_id and hl.lookup_type = 'RETRO_REPROCESS_TYPE' and hl.lookup_code = prcu.reprocess_type

View Text - HTML Formatted

SELECT PRCU.ROWID ROW_ID
, PRCU.RETRO_COMPONENT_USAGE_ID
, PRCU.BUSINESS_GROUP_ID
, PRCU.LEGISLATION_CODE
, PRCU.RETRO_COMPONENT_ID
, PTR.COMPONENT_NAME
, PRCU.CREATOR_ID
, PRCU.CREATOR_TYPE
, PRCU.DEFAULT_COMPONENT
, PRCU.REPROCESS_TYPE
, HL.MEANING D_REPROCESS_TYPE
, PRCU.OBJECT_VERSION_NUMBER
, PRCU.CREATION_DATE
, PRCU.CREATED_BY
, PRCU.LAST_UPDATE_DATE
, PRCU.LAST_UPDATED_BY
, PRCU.LAST_UPDATE_LOGIN
, PRCU.REPLACE_RUN_FLAG
, PRCU.USE_OVERRIDE_DATES
FROM PAY_RETRO_COMPONENT_USAGES PRCU
, PAY_RETRO_COMPONENTS PTR
, HR_LOOKUPS HL
WHERE PTR.RETRO_COMPONENT_ID = PRCU.RETRO_COMPONENT_ID
AND HL.LOOKUP_TYPE = 'RETRO_REPROCESS_TYPE'
AND HL.LOOKUP_CODE = PRCU.REPROCESS_TYPE