View: MSD_DP_PLANNING_PERCENTAGES_V

Product:	MSD - Demand Planning
Description:	Demand Plan Planning Percentages
Implementation/DBA Data:	APPS.MSD_DP_PLANNING_PERCENTAGES_V

View Text

SELECT PCTG.DEMAND_PLAN_ID
, PCTG.DP_SCENARIO_ID
, PCTG.COMPONENT_SEQUENCE_ID
, BOMC.COMPONENT_SEQUENCE_ID
, BOM.BILL_SEQUENCE_ID
, BOM.SR_INSTANCE_ID
, BOM.ORGANIZATION_ID
, BOMC.INVENTORY_ITEM_ID
, BOM.ASSEMBLY_ITEM_ID
, PCTG.DATE_TO
, PCTG.DATE_FROM
, PCTG.PLANNING_FACTOR
, PCTG.PLAN_PERCENT_TYPE
FROM MSC_BOMS BOM
, MSC_BOM_COMPONENTS BOMC
, MSD_DP_SCENARIOS MDC
, MSD_DP_PLANNING_PERCENTAGES PCTG
, MSC_ITEM_ID_LID ILID1
, MSC_ITEM_ID_LID ILID2
WHERE BOM.SR_INSTANCE_ID = BOMC.SR_INSTANCE_ID
AND BOM.PLAN_ID = -1
AND BOM.BILL_SEQUENCE_ID = BOMC.BILL_SEQUENCE_ID
AND BOMC.PLAN_ID = -1
AND BOMC.SR_INSTANCE_ID = ILID1.SR_INSTANCE_ID
AND BOMC.INVENTORY_ITEM_ID = ILID2.INVENTORY_ITEM_ID
AND BOMC.SR_INSTANCE_ID = ILID1.SR_INSTANCE_ID
AND BOMC.USING_ASSEMBLY_ID = ILID1.INVENTORY_ITEM_ID
AND BOMC.SR_INSTANCE_ID = ILID2.SR_INSTANCE_ID
AND BOMC.ORGANIZATION_ID = TO_NUMBER(DECODE(LTRIM( PCTG.SR_ORGANIZATION_PK
, '.0123456789')
, NULL
, PCTG.SR_ORGANIZATION_PK
, -1))
AND TO_NUMBER(DECODE(LTRIM( PCTG.INSTANCE
, '.0123456789')
, NULL
, PCTG.INSTANCE
, -1))= ILID1.SR_INSTANCE_ID
AND TO_NUMBER(DECODE(LTRIM(PCTG.INSTANCE
, '.0123456789')
, NULL
, PCTG.INSTANCE
, -1)) = ILID2.SR_INSTANCE_ID
AND TO_NUMBER(DECODE(LTRIM( PCTG.SR_COMPONENT_ITEM_PK
, '.0123456789')
, NULL
, PCTG.SR_COMPONENT_ITEM_PK
, -1)) = ILID2.SR_INVENTORY_ITEM_ID
AND TO_NUMBER(DECODE(LTRIM( PCTG.SR_ASSEMBLY_ITEM_PK
, '.0123456789')
, NULL
, PCTG.SR_ASSEMBLY_ITEM_PK
, -1)) = ILID1.SR_INVENTORY_ITEM_ID
AND ( PCTG.DATE_FROM BETWEEN BOMC.EFFECTIVITY_DATE
AND NVL(BOMC.DISABLE_DATE
, PCTG.DATE_FROM))
AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND PCTG.PLAN_PERCENT_TYPE = '1'
AND MDC.LAST_REVISION = PCTG.REVISION
AND MDC.SCENARIO_ID = PCTG.DP_SCENARIO_ID
AND MDC.DEMAND_PLAN_ID = PCTG.DEMAND_PLAN_ID
AND BOMC.OPTIONAL_COMPONENT=1

Columns