FOS_QUALIFIER_DEFINITIONS_VL

Details

• Schema: FUSION

• Object owner: FOS

• Object type: VIEW

Columns

Name
QUALIFIER_ID QUALIFIER_CODE QUALIFIER_MEANING GP_QUALIFIER_FLAG IMT_QUALIFIER_FLAG SHIPMENT_QUALIFIER_FLAG DROP_SHIP_QUALIFIER_FLAG SERVICE_SALES_QUALIFIER_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID

Query

SQL_Statement

SELECT B.QUALIFIER_ID, B.QUALIFIER_CODE, T.QUALIFIER_MEANING, B.GP_QUALIFIER_FLAG, B.IMT_QUALIFIER_FLAG, B.SHIPMENT_QUALIFIER_FLAG, B.DROP_SHIP_QUALIFIER_FLAG, B.SERVICE_SALES_QUALIFIER_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ENTERPRISE_ID FROM FOS_QUALIFIER_DEFINITIONS_TL T, FOS_QUALIFIER_DEFINITIONS_B B WHERE T.QUALIFIER_ID = B.QUALIFIER_ID AND T.ENTERPRISE_ID = B.ENTERPRISE_ID AND T.LANGUAGE = USERENV('LANG')