ZCA_ORDERS_SETUP_REF_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
ORDER_SETUP_REF_ID SETUP_REF_CODE TOPOLOGY_REF_CODE ACTIVE_FLAG DEFAULT_FLAG PRIORITY FILTER_CONDITION_FOR_OPTY OPT_IN_REVN_SYNC REVN_RECONCILE_OPTION NAME DESCRIPTION PROCESS_NAME DOCUMENT_NAME REST_FRAMEWORK_VERSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ORDER_SETUP_REF_ID ORDER_SETUP_REF_ID, B.SETUP_REF_CODE SETUP_REF_CODE, B.TOPOLOGY_REF_CODE TOPOLOGY_REF_CODE, B.ACTIVE_FLAG ACTIVE_FLAG, B.DEFAULT_FLAG DEFAULT_FLAG, B.PRIORITY, B.FILTER_CONDITION_FOR_OPTY, B.OPT_IN_REVN_SYNC OPT_IN_REVN_SYNC, B.REVN_RECONCILE_OPTION REVN_RECONCILE_OPTION, TL.NAME NAME, TL.DESCRIPTION DESCRIPTION, B.PROCESS_NAME, B.DOCUMENT_NAME, B.REST_FRAMEWORK_VERSION, 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.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ZCA_ORDERS_SETUP_REF_B B, ZCA_ORDERS_SETUP_REF_TL TL WHERE B.ORDER_SETUP_REF_ID = TL.ORDER_SETUP_REF_ID AND TL.LANGUAGE = USERENV('LANG')