EGO_ITEM_ASSOCIATIONS_PUB_V

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name

ASSOCIATION_ID PARTY_STATUS SUPPLIER_ID SUPPLIER_SITE_ID INVENTORY_ITEM_ID ORGANIZATION_ID STATUS_CODE PRIMARY_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME CHANGE_LINE_ID VERSION_ID ACD_TYPE VERSION_START_DATE VERSION_END_DATE IMPLEMENTATION_DATE CHANGE_BIT_MAP JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE STYLE_ITEM_ID

Query

SQL_Statement

SELECT ASSOCIATION_ID ,PARTY_STATUS ,SUPPLIER_ID ,SUPPLIER_SITE_ID ,INVENTORY_ITEM_ID ,ORGANIZATION_ID ,STATUS_CODE ,PRIMARY_FLAG ,OBJECT_VERSION_NUMBER ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,REQUEST_ID ,PROGRAM_NAME ,PROGRAM_APP_NAME ,CHANGE_LINE_ID ,VERSION_ID ,ACD_TYPE ,VERSION_START_DATE ,VERSION_END_DATE ,IMPLEMENTATION_DATE ,CHANGE_BIT_MAP ,JOB_DEFINITION_NAME ,JOB_DEFINITION_PACKAGE ,STYLE_ITEM_ID FROM EGO_ITEM_ASSOCIATIONS UNION SELECT ASSOCIATION_ID ,PARTY_STATUS ,SUPPLIER_ID ,SUPPLIER_SITE_ID ,INVENTORY_ITEM_ID ,ORGANIZATION_ID ,STATUS_CODE ,PRIMARY_FLAG ,OBJECT_VERSION_NUMBER ,CREATED_BY ,CREATION_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATE_LOGIN ,REQUEST_ID ,PROGRAM_NAME ,PROGRAM_APP_NAME ,CHANGE_LINE_ID ,VERSION_ID ,ACD_TYPE ,VERSION_START_DATE ,VERSION_END_DATE ,IMPLEMENTATION_DATE ,CHANGE_BIT_MAP ,JOB_DEFINITION_NAME ,JOB_DEFINITION_PACKAGE ,STYLE_ITEM_ID FROM EGO_ITEM_ASSOCIATIONS_ WHERE AUDIT_ACTION_TYPE_ = 'DELETE'