MSC_ANALYTIC_FACT_PEG

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID TRANSACTION_ID SUPPLY_ORDER_TYPE INVENTORY_ITEM_ID ORGANIZATION_ID SUPPLY_ORDER_QTY SUPPLY_ORDER_DATE SUPPLIER_ID SUPPLIER_SITE_ID DEMAND_ID DEMAND_ORDER_TYPE DEMAND_ORDER_ITEM_ID DEMAND_ORDER_ORGANIZATION DEMAND_ORDER_QTY DEMAND_ORDER_DATE USING_ASSEMBLY_DEMAND_DATE CUSTOMER_ID CUSTOMER_SITE_ID PEGGED_QTY

Name

PLAN_ID

TRANSACTION_ID

SUPPLY_ORDER_TYPE

INVENTORY_ITEM_ID

ORGANIZATION_ID

SUPPLY_ORDER_QTY

SUPPLY_ORDER_DATE

SUPPLIER_ID

SUPPLIER_SITE_ID

DEMAND_ID

DEMAND_ORDER_TYPE

DEMAND_ORDER_ITEM_ID

DEMAND_ORDER_ORGANIZATION

DEMAND_ORDER_QTY

DEMAND_ORDER_DATE

USING_ASSEMBLY_DEMAND_DATE

CUSTOMER_ID

CUSTOMER_SITE_ID

PEGGED_QTY

Query

SQL_Statement
select s.plan_id, s.transaction_id, s.order_type supply_order_type, s.inventory_item_id inventory_item_id, s.organization_id organization_id, s.new_order_quantity supply_order_qty, TRUNC(TO_DATE(s.NEW_SCHEDULE_DATE)) As supply_order_date, s.supplier_id, s.supplier_site_id, d.demand_id, d.origination_type demand_order_type, d.inventory_item_id demand_order_item_id, d.organization_id demand_order_organization, (NVL(d.daily_demand_rate, d.using_requirement_quantity)) * NVL( d.probability, 1) demand_order_qty , TRUNC(TO_DATE(d.USING_ASSEMBLY_DEMAND_DATE)) As demand_order_date, d.using_assembly_demand_date, d.customer_id , d.customer_site_id, ps.allocated_quantity pegged_qty from msc_full_pegging ps, msc_full_pegging pe, msc_demands d, msc_supplies s, msc_plan_definitions mp where s.transaction_id=ps.transaction_id and s.plan_id=ps.plan_id and pe.pegging_id=nvl( ps.end_pegging_id,ps.pegging_id) and ps.plan_id=pe.plan_id and pe.demand_id=d.demand_id and pe.plan_id=d.plan_id and s.plan_id=d.plan_id and mp.plan_id = ps.plan_id and mp.expose_to_analytic = 1

SQL_Statement

select s.plan_id,

s.transaction_id,

s.order_type supply_order_type,

s.inventory_item_id inventory_item_id,

s.organization_id organization_id,

s.new_order_quantity supply_order_qty,

TRUNC(TO_DATE(s.NEW_SCHEDULE_DATE)) As supply_order_date,

s.supplier_id,

s.supplier_site_id,

d.demand_id,

d.origination_type demand_order_type,

d.inventory_item_id demand_order_item_id,

d.organization_id demand_order_organization,

(NVL(d.daily_demand_rate, d.using_requirement_quantity)) * NVL( d.probability, 1) demand_order_qty ,

TRUNC(TO_DATE(d.USING_ASSEMBLY_DEMAND_DATE)) As demand_order_date,

d.using_assembly_demand_date,

d.customer_id ,

d.customer_site_id,

ps.allocated_quantity pegged_qty

from

msc_full_pegging ps,

msc_full_pegging pe,

msc_demands d,

msc_supplies s,

msc_plan_definitions mp

where

s.transaction_id=ps.transaction_id and

s.plan_id=ps.plan_id and

pe.pegging_id=nvl( ps.end_pegging_id,ps.pegging_id) and

ps.plan_id=pe.plan_id and

pe.demand_id=d.demand_id and

pe.plan_id=d.plan_id and

s.plan_id=d.plan_id and

mp.plan_id = ps.plan_id and

mp.expose_to_analytic = 1