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' ) |