EGP_ITEM_CATEGORIES_AUDIT_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID CATEGORY_SET_ID CATEGORY_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID SEQUENCE_NUMBER PROGRAM_NAME PROGRAM_APP_NAME JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ALT_ITEM_CAT_CODE ITEM_CATEGORY_ASSIGNMENT_ID START_DATE END_DATE

Query

SQL_Statement

SELECT ITEMCATS.inventory_item_id, ITEMS.organization_id, ITEMCATS.category_set_id, ITEMCATS.category_id, ITEMCATS.object_version_number, ITEMCATS.last_update_date, ITEMCATS.last_updated_by, ITEMCATS.creation_date, ITEMCATS.created_by, ITEMCATS.last_update_login, ITEMCATS.request_id, ITEMCATS.sequence_number, ITEMCATS.program_name, ITEMCATS.program_app_name, ITEMCATS.job_definition_name, ITEMCATS.job_definition_package, ITEMCATS.alt_item_cat_code, ITEMCATS.item_category_assignment_id, ITEMCATS.start_date, ITEMCATS.end_date FROM egp_item_cat_assignments_ ITEMCATS, egp_category_sets_b CATSETS, egp_item_org_associations ITEMS, inv_org_parameters ORG WHERE CATSETS.category_set_id = ITEMCATS.category_set_id AND ITEMS.inventory_item_id = ITEMCATS.inventory_item_id AND ORG.organization_id = ITEMS.organization_id AND ITEMCATS.audit_action_type_ = 'DELETE' AND ( ( CATSETS.control_level = 1 AND ITEMCATS.organization_id = ORG.master_organization_id ) OR ( CATSETS.control_level = 2 AND ITEMCATS.organization_id = ORG.item_definition_org_id ) )