CST_XLA_ORG_PARAMETERS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

INV_ORG_ID

INV_ORG_CODE

MASTER_ORGANIZATION_ID

BUSINESS_UNIT_ID

LEGAL_ENTITY_ID

DISTRIBUTED_ORGANIZATION_FLAG

INVENTORY_FLAG

WCS_ENABLED_FLAG

EAM_ENABLED_FLAG

WMS_ENABLED_FLAG

PROJECT_REFERENCE_ENABLED

PM_COST_COLLECTION_ENABLED

STANDARD_PACK_ENABLED

ORG_PARAMS_ATTRIBUTE_CATEGORY

ORG_PARAMS_ATTRIBUTE1

ORG_PARAMS_ATTRIBUTE2

ORG_PARAMS_ATTRIBUTE3

ORG_PARAMS_ATTRIBUTE4

ORG_PARAMS_ATTRIBUTE5

ORG_PARAMS_ATTRIBUTE6

ORG_PARAMS_ATTRIBUTE7

ORG_PARAMS_ATTRIBUTE8

ORG_PARAMS_ATTRIBUTE9

ORG_PARAMS_ATTRIBUTE10

ORG_PARAMS_ATTRIBUTE11

ORG_PARAMS_ATTRIBUTE12

ORG_PARAMS_ATTRIBUTE13

ORG_PARAMS_ATTRIBUTE14

ORG_PARAMS_ATTRIBUTE15

Query

SQL_Statement

SELECT organization_id inv_org_id

, organization_code inv_org_code

, master_organization_id master_organization_id

, profit_center_bu_id business_unit_id

, legal_entity_id legal_entity_id

, distributed_organization_flag distributed_organization_flag

, inventory_flag inventory_flag

, wcs_enabled wcs_enabled_flag

, eam_enabled_flag eam_enabled_flag

, wms_enabled_flag wms_enabled_flag

, project_reference_enabled project_reference_enabled

, pm_cost_collection_enabled pm_cost_collection_enabled

, standard_pack_enabled standard_pack_enabled

, attribute_category org_params_attribute_category

, attribute1 org_params_attribute1

, attribute2 org_params_attribute2

, attribute3 org_params_attribute3

, attribute4 org_params_attribute4

, attribute5 org_params_attribute5

, attribute6 org_params_attribute6

, attribute7 org_params_attribute7

, attribute8 org_params_attribute8

, attribute9 org_params_attribute9

, attribute10 org_params_attribute10

, attribute11 org_params_attribute11

, attribute12 org_params_attribute12

, attribute13 org_params_attribute13

, attribute14 org_params_attribute14

, attribute15 org_params_attribute15

FROM inv_org_parameters