EGP_ITEM_ORG_ASSOC_PUB_V

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID INVENTORY_ORGANIZATION_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE LAST_UPDATE_DATE CREATION_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CREATED_BY LAST_UPDATED_BY ITEM_DEFINITION_ORG_ID PUBLIC_FLAG CHANGE_ROW_FLAG

Query

SQL_Statement

SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, INVENTORY_ORGANIZATION_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, CREATED_BY, LAST_UPDATED_BY, ITEM_DEFINITION_ORG_ID, PUBLIC_FLAG, CHANGE_ROW_FLAG FROM EGP_ITEM_ORG_ASSOCIATIONS UNION ( SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, INVENTORY_ORGANIZATION_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, CREATED_BY, LAST_UPDATED_BY, ITEM_DEFINITION_ORG_ID, PUBLIC_FLAG, CHANGE_ROW_FLAG FROM EGP_ITEM_ORG_ASSOCIATIONS_ WHERE AUDIT_ACTION_TYPE_ = 'DELETE' )