EGI_SUBSCRIPTIONS_VL

Details

• Schema: FUSION

• Object owner: EGI

• Object type: VIEW

Columns

Name
SUBSCRIPTION_ID SUPPLIER_ID SUBSCRIPTION_DESTINATION COMMENTS SUBSCRIPTION_NAME SUBSCRIPTION_NUMBER SUBSCRIPTION_MODE SUBSCRIPTION_TYPE SUBSCRIPTION_STATUS GLOBAL_LOCATION_NUMBER CATEGORY_ID ORGANIZATION_ID RELOAD_FULL_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DATE_SUBMITTED ERROR_CODE ACK_DETAIL GTIN_NUMBER

Query

SQL_Statement

SELECT B.SUBSCRIPTION_ID SUBSCRIPTION_ID, B.SUPPLIER_ID SUPPLIER_ID, B.SUBSCRIPTION_DESTINATION SUBSCRIPTION_DESTINATION, TL.COMMENTS COMMENTS, TL.SUBSCRIPTION_NAME SUBSCRIPTION_NAME, B.SUBSCRIPTION_NUMBER SUBSCRIPTION_NUMBER, B.SUBSCRIPTION_MODE SUBSCRIPTION_MODE, B.SUBSCRIPTION_TYPE SUBSCRIPTION_TYPE, B.SUBSCRIPTION_STATUS SUBSCRIPTION_STATUS, B.GLOBAL_LOCATION_NUMBER GLOBAL_LOCATION_NUMBER, B.CATEGORY_ID CATEGORY_ID, B.ORGANIZATION_ID ORGANIZATION_ID, B.RELOAD_FULL_FLAG RELOAD_FULL_FLAG, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.DATE_SUBMITTED, B.ERROR_CODE, B.ACK_DETAIL , B.GTIN_NUMBER FROM EGI_SUBSCRIPTIONS_B B, EGI_SUBSCRIPTIONS_TL TL WHERE B.SUBSCRIPTION_ID = TL.SUBSCRIPTION_ID AND TL.LANGUAGE = USERENV('LANG')