CMK_SERVICE_PROVIDERS_VL

Details

• Schema: FUSION

• Object owner: CMK

• Object type: VIEW

Columns

Name

SERVICE_PROVIDER_ID OBN_ID SERVICE_PROVIDER_NAME SP_EXT_PARTNER_ID EXT_PARTNER_ID EXT_PARTNER_ID_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID DESCRIPTION EXT_MSG_TYPE_TAG EXT_MSG_VERSION_TAG EXT_MSG_STANDARD_TAG SERVICE_PROVIDER_ID_TAG FROM_PARTNER_ID_TAG FROM_PARTNER_ID_TYPE_TAG TO_PARTNER_ID_TAG TO_PARTNER_ID_TYPE_TAG DEL_STATUS_UPDATE_ENABLED MSG_EXCHANGE_STANDARD PREDEFINED_ENDPT_IND USER_DEFINED SP_CATEGORY ATTCH_PROCESS_MTHD CONNECTION_TYPE ELECTRONIC_INVOICE_BU

Query

SQL_Statement

SELECT CMK_SERVICE_PROVIDERS_B.SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID, CMK_SERVICE_PROVIDERS_B.OBN_ID OBN_ID, CMK_SERVICE_PROVIDERS_B.SERVICE_PROVIDER_NAME SERVICE_PROVIDER_NAME, CMK_SERVICE_PROVIDERS_B.SP_EXT_PARTNER_ID SP_EXT_PARTNER_ID, CMK_SERVICE_PROVIDERS_B.EXT_PARTNER_ID EXT_PARTNER_ID, CMK_SERVICE_PROVIDERS_B.EXT_PARTNER_ID_TYPE EXT_PARTNER_ID_TYPE, CMK_SERVICE_PROVIDERS_B.CREATED_BY CREATED_BY, CMK_SERVICE_PROVIDERS_B.CREATION_DATE CREATION_DATE, CMK_SERVICE_PROVIDERS_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMK_SERVICE_PROVIDERS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMK_SERVICE_PROVIDERS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMK_SERVICE_PROVIDERS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMK_SERVICE_PROVIDERS_B.MODULE_ID MODULE_ID, CMK_SERVICE_PROVIDERS_TL.DESCRIPTION DESCRIPTION, CMK_SERVICE_PROVIDERS_B.EXT_MSG_TYPE_TAG, CMK_SERVICE_PROVIDERS_B.EXT_MSG_VERSION_TAG, CMK_SERVICE_PROVIDERS_B.EXT_MSG_STANDARD_TAG, CMK_SERVICE_PROVIDERS_B.SERVICE_PROVIDER_ID_TAG, CMK_SERVICE_PROVIDERS_B.FROM_PARTNER_ID_TAG, CMK_SERVICE_PROVIDERS_B.FROM_PARTNER_ID_TYPE_TAG, CMK_SERVICE_PROVIDERS_B.TO_PARTNER_ID_TAG, CMK_SERVICE_PROVIDERS_B.TO_PARTNER_ID_TYPE_TAG, CMK_SERVICE_PROVIDERS_B.DEL_STATUS_UPDATE_ENABLED, CMK_SERVICE_PROVIDERS_B.MSG_EXCHANGE_STANDARD, CMK_SERVICE_PROVIDERS_B.PREDEFINED_ENDPT_IND, CMK_SERVICE_PROVIDERS_B.USER_DEFINED, CMK_SERVICE_PROVIDERS_B.SP_CATEGORY, CMK_SERVICE_PROVIDERS_B.ATTCH_PROCESS_MTHD, CMK_SERVICE_PROVIDERS_B.CONNECTION_TYPE, CMK_SERVICE_PROVIDERS_B.ELECTRONIC_INVOICE_BU FROM CMK_SERVICE_PROVIDERS_B, CMK_SERVICE_PROVIDERS_TL WHERE CMK_SERVICE_PROVIDERS_B.SERVICE_PROVIDER_ID = CMK_SERVICE_PROVIDERS_TL.SERVICE_PROVIDER_ID AND CMK_SERVICE_PROVIDERS_TL.LANGUAGE = USERENV('LANG')