VIEW: CS.CS_SYSTEM_PARAMETERS_ALL#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SERVICE_ENTITY_ID SERVICE_ENTITY_ID, CREATE_SYSTEMS_FLAG CREATE_SYSTEMS_FLAG, REQUIRE_SERVICE_CONTRACT_FLAG REQUIRE_SERVICE_CONTRACT_FLAG, PARTIAL_PRODUCT_SPEC_FLAG PARTIAL_PRODUCT_SPEC_FLAG, MANUFACTURING_ORG_ID MANUFACTURING_ORG_ID, SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE, REMOTE_PCR_FLAG REMOTE_PCR_FLAG, AUDIT_FLAG AUDIT_FLAG, AUDIT_SERVICE_ENTITY_FLAG AUDIT_SERVICE_ENTITY_FLAG, AUDIT_INCIDENT_STATUS_FLAG AUDIT_INCIDENT_STATUS_FLAG, AUDIT_INCIDENT_TYPE_FLAG AUDIT_INCIDENT_TYPE_FLAG, AUDIT_INCIDENT_URGENCY_FLAG AUDIT_INCIDENT_URGENCY_FLAG, AUDIT_INCIDENT_SEVERITY_FLAG AUDIT_INCIDENT_SEVERITY_FLAG, AUDIT_RESPONSIBLE_GROUP_FLAG AUDIT_RESPONSIBLE_GROUP_FLAG, AUDIT_INCIDENT_OWNER_FLAG AUDIT_INCIDENT_OWNER_FLAG, AUDIT_INVENTORY_ITEM_FLAG AUDIT_INVENTORY_ITEM_FLAG, AUDIT_COMPONENT_ITEM_FLAG AUDIT_COMPONENT_ITEM_FLAG, AUDIT_EXPECTED_RES_DATE_FLAG AUDIT_EXPECTED_RES_DATE_FLAG, AUDIT_EXPECTED_REVISION_FLAG AUDIT_EXPECTED_REVISION_FLAG, USE_ACCESS_CONTROL_FLAG USE_ACCESS_CONTROL_FLAG, ACCESS_TEMPLATE_ENTITY_CODE ACCESS_TEMPLATE_ENTITY_CODE, INC_CONTACT_VALIDATED_FLAG INC_CONTACT_VALIDATED_FLAG, INC_CONTACT_TYPE_CODE INC_CONTACT_TYPE_CODE, INC_SERVICE_VALIDATION_CODE INC_SERVICE_VALIDATION_CODE, SYSTEM_DECISION_WINDOW_CODE SYSTEM_DECISION_WINDOW_CODE, LAST_DR_MTL_XNS_ID LAST_DR_MTL_XNS_ID, USE_DEPOT_REPAIR_FLAG USE_DEPOT_REPAIR_FLAG, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT, USE_CONTRACTS_FLAG USE_CONTRACTS_FLAG, ROUND_TO_UOM ROUND_TO_UOM, CONV_TO_ENTERED_UOM_FLG CONV_TO_ENTERED_UOM_FLG, CHANGE_END_TIME_FLAG CHANGE_END_TIME_FLAG, USE_MOBILE_FLD_SRV_FLAG USE_MOBILE_FLD_SRV_FLAG, USE_CUSTOMER_CARE USE_CUSTOMER_CARE, USE_COMM_SERVICES USE_COMM_SERVICES, INTERACTION_HIST_DISPLAY INTERACTION_HIST_DISPLAY from "CS"."CS_SYSTEM_PARAMETERS_ALL"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SERVICE_ENTITY_ID SERVICE_ENTITY_ID
, CREATE_SYSTEMS_FLAG CREATE_SYSTEMS_FLAG
, REQUIRE_SERVICE_CONTRACT_FLAG REQUIRE_SERVICE_CONTRACT_FLAG
, PARTIAL_PRODUCT_SPEC_FLAG PARTIAL_PRODUCT_SPEC_FLAG
, MANUFACTURING_ORG_ID MANUFACTURING_ORG_ID
, SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, REMOTE_PCR_FLAG REMOTE_PCR_FLAG
, AUDIT_FLAG AUDIT_FLAG
, AUDIT_SERVICE_ENTITY_FLAG AUDIT_SERVICE_ENTITY_FLAG
, AUDIT_INCIDENT_STATUS_FLAG AUDIT_INCIDENT_STATUS_FLAG
, AUDIT_INCIDENT_TYPE_FLAG AUDIT_INCIDENT_TYPE_FLAG
, AUDIT_INCIDENT_URGENCY_FLAG AUDIT_INCIDENT_URGENCY_FLAG
, AUDIT_INCIDENT_SEVERITY_FLAG AUDIT_INCIDENT_SEVERITY_FLAG
, AUDIT_RESPONSIBLE_GROUP_FLAG AUDIT_RESPONSIBLE_GROUP_FLAG
, AUDIT_INCIDENT_OWNER_FLAG AUDIT_INCIDENT_OWNER_FLAG
, AUDIT_INVENTORY_ITEM_FLAG AUDIT_INVENTORY_ITEM_FLAG
, AUDIT_COMPONENT_ITEM_FLAG AUDIT_COMPONENT_ITEM_FLAG
, AUDIT_EXPECTED_RES_DATE_FLAG AUDIT_EXPECTED_RES_DATE_FLAG
, AUDIT_EXPECTED_REVISION_FLAG AUDIT_EXPECTED_REVISION_FLAG
, USE_ACCESS_CONTROL_FLAG USE_ACCESS_CONTROL_FLAG
, ACCESS_TEMPLATE_ENTITY_CODE ACCESS_TEMPLATE_ENTITY_CODE
, INC_CONTACT_VALIDATED_FLAG INC_CONTACT_VALIDATED_FLAG
, INC_CONTACT_TYPE_CODE INC_CONTACT_TYPE_CODE
, INC_SERVICE_VALIDATION_CODE INC_SERVICE_VALIDATION_CODE
, SYSTEM_DECISION_WINDOW_CODE SYSTEM_DECISION_WINDOW_CODE
, LAST_DR_MTL_XNS_ID LAST_DR_MTL_XNS_ID
, USE_DEPOT_REPAIR_FLAG USE_DEPOT_REPAIR_FLAG
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
, USE_CONTRACTS_FLAG USE_CONTRACTS_FLAG
, ROUND_TO_UOM ROUND_TO_UOM
, CONV_TO_ENTERED_UOM_FLG CONV_TO_ENTERED_UOM_FLG
, CHANGE_END_TIME_FLAG CHANGE_END_TIME_FLAG
, USE_MOBILE_FLD_SRV_FLAG USE_MOBILE_FLD_SRV_FLAG
, USE_CUSTOMER_CARE USE_CUSTOMER_CARE
, USE_COMM_SERVICES USE_COMM_SERVICES
, INTERACTION_HIST_DISPLAY INTERACTION_HIST_DISPLAY
FROM "CS"."CS_SYSTEM_PARAMETERS_ALL"