VIEW: MSD.MSD_DP_PLANNING_PERCENTAGES#

Source

View Text - Preformatted

select DEMAND_PLAN_ID DEMAND_PLAN_ID, DP_SCENARIO_ID DP_SCENARIO_ID, REVISION REVISION, INSTANCE INSTANCE, SR_ORGANIZATION_PK SR_ORGANIZATION_PK, ORGANIZATION_LEVEL_PK ORGANIZATION_LEVEL_PK, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, SR_ASSEMBLY_ITEM_PK SR_ASSEMBLY_ITEM_PK, ASSEMBLY_ITEM_LEVEL_PK ASSEMBLY_ITEM_LEVEL_PK, SR_COMPONENT_ITEM_PK SR_COMPONENT_ITEM_PK, COMPONENT_ITEM_LEVEL_PK COMPONENT_ITEM_LEVEL_PK, PLANNING_FACTOR PLANNING_FACTOR, DATE_FROM DATE_FROM, DATE_TO DATE_TO, PLAN_PERCENT_TYPE PLAN_PERCENT_TYPE, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "MSD"."MSD_DP_PLANNING_PERCENTAGES"

View Text - HTML Formatted

SELECT DEMAND_PLAN_ID DEMAND_PLAN_ID
, DP_SCENARIO_ID DP_SCENARIO_ID
, REVISION REVISION
, INSTANCE INSTANCE
, SR_ORGANIZATION_PK SR_ORGANIZATION_PK
, ORGANIZATION_LEVEL_PK ORGANIZATION_LEVEL_PK
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, SR_ASSEMBLY_ITEM_PK SR_ASSEMBLY_ITEM_PK
, ASSEMBLY_ITEM_LEVEL_PK ASSEMBLY_ITEM_LEVEL_PK
, SR_COMPONENT_ITEM_PK SR_COMPONENT_ITEM_PK
, COMPONENT_ITEM_LEVEL_PK COMPONENT_ITEM_LEVEL_PK
, PLANNING_FACTOR PLANNING_FACTOR
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, PLAN_PERCENT_TYPE PLAN_PERCENT_TYPE
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "MSD"."MSD_DP_PLANNING_PERCENTAGES"