MSC_ANALYTIC_FACT_PEG_V
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 |
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 |