MSC_ANALYTIC_FACT_BM

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
DEMAND_ID INVENTORY_ITEM_ID ORGANIZATION_ID CUSTOMER_ID CUSTOMER_SITE_ID SUPPLIER_ID SUPPLIER_SITE_ID DEMAND_CLASS ORDER_NUMBER ORDER_DATE_TYPE_CODE DEMAND_QUANTITY REQUESTED_DATE_QUANTITY PROMISED_QUANTITY SHIP_SET_NAME ORDER_REVENUE REQUESTED_DATE NEW_PROMISED_DATE OLD_PROMISED_DATE SCHEDULED_DATE EXPECTED_DATE DEMAND_LEAD_TIME_DATE EXPECTED_SUPPLIER_ID EXPECTED_SUPPLIER_SITE_ID ORDERED_DATE FULFILLMENT_COST RECEIVING_ORG_ID ORDERED_UOM ROOT_FULFILLMENT_LINE PARENT_FULFILLMENT_LINE FULFILLMENT_LINE SELLING_PRICE PLAN_ID

Name

DEMAND_ID

INVENTORY_ITEM_ID

ORGANIZATION_ID

CUSTOMER_ID

CUSTOMER_SITE_ID

SUPPLIER_ID

SUPPLIER_SITE_ID

DEMAND_CLASS

ORDER_NUMBER

ORDER_DATE_TYPE_CODE

DEMAND_QUANTITY

REQUESTED_DATE_QUANTITY

PROMISED_QUANTITY

SHIP_SET_NAME

ORDER_REVENUE

REQUESTED_DATE

NEW_PROMISED_DATE

OLD_PROMISED_DATE

SCHEDULED_DATE

EXPECTED_DATE

DEMAND_LEAD_TIME_DATE

EXPECTED_SUPPLIER_ID

EXPECTED_SUPPLIER_SITE_ID

ORDERED_DATE

FULFILLMENT_COST

RECEIVING_ORG_ID

ORDERED_UOM

ROOT_FULFILLMENT_LINE

PARENT_FULFILLMENT_LINE

FULFILLMENT_LINE

SELLING_PRICE

PLAN_ID

Query

SQL_Statement
select bmrun.DEMAND_ID, bmrun.INVENTORY_ITEM_ID, bmrun.ORGANIZATION_ID, bmrun.CUSTOMER_ID, bmrun.CUSTOMER_SITE_ID, bmrun.SUPPLIER_ID, bmrun.SUPPLIER_SITE_ID, bmrun.DEMAND_CLASS, bmrun.ORDER_NUMBER, bmrun.ORDER_DATE_TYPE_CODE, bmrun.DEMAND_QUANTITY, bmrun.REQUESTED_DATE_QUANTITY, bmrun.PROMISED_QUANTITY, bmrun.SHIP_SET_NAME, bmrun.ORDER_REVENUE, bmrun.REQUESTED_DATE, bmrun.NEW_PROMISED_DATE, bmrun.OLD_PROMISED_DATE, DECODE( demands.ORDER_DATE_TYPE_CODE, 1, demands.schedule_ship_date, 2, demands.schedule_arrival_date, demands.USING_ASSEMBLY_DEMAND_DATE) AS Scheduled_Date, DECODE( demands.ORDER_DATE_TYPE_CODE, 1, bmrun.expected_ship_date, 2, bmrun.expected_arrival_date, bmrun.expected_ship_date) AS Expected_Date, nvl(bmrun.USR_DEF_DMD_LEAD_TIME_DATE,bmrun.DEMAND_LEAD_TIME_DATE) as DEMAND_LEAD_TIME_DATE, bmrun.EXPECTED_SUPPLIER_ID, bmrun.EXPECTED_SUPPLIER_SITE_ID, demands.ORDERED_DATE, demands.FULFILLMENT_COST, demands.RECEIVING_ORG_ID, demands.ORDERED_UOM, demands.ROOT_FULFILLMENT_LINE, demands.PARENT_FULFILLMENT_LINE, demands.sales_order_line_id AS Fulfillment_line, demands.SELLING_PRICE, demands.PLAN_ID from MSC_BM_RUN_DEMANDS bmrun, MSC_DEMANDS demands where bmrun.BM_RUN_ID = -1 and demands.plan_id = -1 and bmrun.DEMAND_ID = demands.DEMAND_ID

SQL_Statement

select

bmrun.DEMAND_ID,

bmrun.INVENTORY_ITEM_ID,

bmrun.ORGANIZATION_ID,

bmrun.CUSTOMER_ID,

bmrun.CUSTOMER_SITE_ID,

bmrun.SUPPLIER_ID,

bmrun.SUPPLIER_SITE_ID,

bmrun.DEMAND_CLASS,

bmrun.ORDER_NUMBER,

bmrun.ORDER_DATE_TYPE_CODE,

bmrun.DEMAND_QUANTITY,

bmrun.REQUESTED_DATE_QUANTITY,

bmrun.PROMISED_QUANTITY,

bmrun.SHIP_SET_NAME,

bmrun.ORDER_REVENUE,

bmrun.REQUESTED_DATE,

bmrun.NEW_PROMISED_DATE,

bmrun.OLD_PROMISED_DATE,

DECODE( demands.ORDER_DATE_TYPE_CODE, 1, demands.schedule_ship_date, 2, demands.schedule_arrival_date, demands.USING_ASSEMBLY_DEMAND_DATE) AS Scheduled_Date,

DECODE( demands.ORDER_DATE_TYPE_CODE, 1, bmrun.expected_ship_date, 2, bmrun.expected_arrival_date, bmrun.expected_ship_date) AS Expected_Date,

nvl(bmrun.USR_DEF_DMD_LEAD_TIME_DATE,bmrun.DEMAND_LEAD_TIME_DATE) as DEMAND_LEAD_TIME_DATE,

bmrun.EXPECTED_SUPPLIER_ID,

bmrun.EXPECTED_SUPPLIER_SITE_ID,

demands.ORDERED_DATE,

demands.FULFILLMENT_COST,

demands.RECEIVING_ORG_ID,

demands.ORDERED_UOM,

demands.ROOT_FULFILLMENT_LINE,

demands.PARENT_FULFILLMENT_LINE,

demands.sales_order_line_id AS Fulfillment_line,

demands.SELLING_PRICE,

demands.PLAN_ID

from MSC_BM_RUN_DEMANDS bmrun, MSC_DEMANDS demands

where bmrun.BM_RUN_ID = -1 and demands.plan_id = -1

and bmrun.DEMAND_ID = demands.DEMAND_ID