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