EGP_ITEM_CAT_ASSIGNMENTS_PUB_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ITEM_CATEGORY_ASSIGNMENT_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 START_DATE END_DATE

Query

SQL_Statement

SELECT INVENTORY_ITEM_ID, ITEM_CATEGORY_ASSIGNMENT_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, START_DATE, END_DATE FROM EGP_ITEM_CAT_ASSIGNMENTS UNION ( SELECT INVENTORY_ITEM_ID, ITEM_CATEGORY_ASSIGNMENT_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, START_DATE, END_DATE FROM EGP_ITEM_CAT_ASSIGNMENTS_ WHERE AUDIT_ACTION_TYPE_ = 'DELETE' )