VIEW: APPS.PAY_KR_YER_ARCHIVES_V

Source

View Text - Preformatted

SELECT v.row_id, v.archive_item_id, v.user_entity_id, v.assignment_action_id context1, v.value, v.archive_type, itm.updatable_flag, itm.display_sequence, v.last_update_date, v.last_updated_by, v.last_update_login, v.created_by, v.creation_date, v.object_version_number, v.user_name, v.data_type from pay_report_format_items_f itm, ( SELECT ppa.report_type, ppa.report_qualifier, ppa.report_category, ppa.effective_date, paa.assignment_action_id, ach.rowid row_id, ach.archive_item_id, ach.user_entity_id, ach.value, ach.archive_type, ach.last_update_date, ach.last_updated_by, ach.last_update_login, ach.created_by, ach.creation_date, ach.object_version_number, dbi.user_name, dbi.data_type from ff_database_items dbi, ff_archive_items ach, pay_payroll_actions ppa, pay_assignment_actions paa WHERE ppa.payroll_action_id = paa.payroll_action_id and ach.context1 = paa.assignment_action_id and nvl(ach.archive_type, 'AAP') in ('AAP', 'AAC') and dbi.user_entity_id = ach.user_entity_id ) v where itm.report_type(+) = v.report_type and itm.report_qualifier(+) = v.report_qualifier and itm.report_category(+) = v.report_category and itm.user_entity_id(+) = v.user_entity_id and v.effective_date between itm.effective_start_date(+) and itm.effective_end_date(+)

View Text - HTML Formatted

SELECT V.ROW_ID
, V.ARCHIVE_ITEM_ID
, V.USER_ENTITY_ID
, V.ASSIGNMENT_ACTION_ID CONTEXT1
, V.VALUE
, V.ARCHIVE_TYPE
, ITM.UPDATABLE_FLAG
, ITM.DISPLAY_SEQUENCE
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.CREATED_BY
, V.CREATION_DATE
, V.OBJECT_VERSION_NUMBER
, V.USER_NAME
, V.DATA_TYPE
FROM PAY_REPORT_FORMAT_ITEMS_F ITM
, ( SELECT PPA.REPORT_TYPE
, PPA.REPORT_QUALIFIER
, PPA.REPORT_CATEGORY
, PPA.EFFECTIVE_DATE
, PAA.ASSIGNMENT_ACTION_ID
, ACH.ROWID ROW_ID
, ACH.ARCHIVE_ITEM_ID
, ACH.USER_ENTITY_ID
, ACH.VALUE
, ACH.ARCHIVE_TYPE
, ACH.LAST_UPDATE_DATE
, ACH.LAST_UPDATED_BY
, ACH.LAST_UPDATE_LOGIN
, ACH.CREATED_BY
, ACH.CREATION_DATE
, ACH.OBJECT_VERSION_NUMBER
, DBI.USER_NAME
, DBI.DATA_TYPE
FROM FF_DATABASE_ITEMS DBI
, FF_ARCHIVE_ITEMS ACH
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND ACH.CONTEXT1 = PAA.ASSIGNMENT_ACTION_ID
AND NVL(ACH.ARCHIVE_TYPE
, 'AAP') IN ('AAP'
, 'AAC')
AND DBI.USER_ENTITY_ID = ACH.USER_ENTITY_ID ) V
WHERE ITM.REPORT_TYPE(+) = V.REPORT_TYPE
AND ITM.REPORT_QUALIFIER(+) = V.REPORT_QUALIFIER
AND ITM.REPORT_CATEGORY(+) = V.REPORT_CATEGORY
AND ITM.USER_ENTITY_ID(+) = V.USER_ENTITY_ID
AND V.EFFECTIVE_DATE BETWEEN ITM.EFFECTIVE_START_DATE(+)
AND ITM.EFFECTIVE_END_DATE(+)