1. Tables and Views for SCM
  2. MSC_ORDERS_BM_V

MSC_ORDERS_BM_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

BM_RUN_ID

DEMAND_LEAD_TIME_DATE

USR_DEF_DMD_LEAD_TIME_DATE

DEMAND_FULFILLMENT_LEAD_TIME

REASON_CODE

DEMAND_PRIORITY

NEW_PROMISED_DATE

OLD_PROMISED_DATE

SOURCE_ORGANIZATION_ID

FIRM_SALES_ORDER

FIRM_SHIP_FROM_ORG

FIRM_SHIP_SET_NAME

FIRM_ARRIVAL_SET_NAME

EARLIEST_PROMISED_DATE

EXPECTED_SHIP_DATE

EXPECTED_ARRIVAL_DATE

SCHEDULING_STATUS_CODE

ECC_FLAG

PULL_IN_FLAG

MANUAL_OVERRIDE_FLAG

EXPECTED_SHIP_METHOD_ID

EXPECTED_CARRIER_ID

EXPECTED_SERVICE_LEVEL_ID

EXPECTED_SUPPLIER_ID

EXPECTED_MODE_OF_TRANSPORT_ID

EXPECTED_SUPPLIER_SITE_ID

EXPECTED_ORGANIZATION_ID

EXPECTED_SHIP_FROM_WAREHOUSE

EXPECTED_SHIP_FROM_WARE_NAME

EXPECTED_DSHIP_SUPPLIER

EXPECTED_DSHIP_SUPP_SITE

EXPECTED_CARRIER

DEMAND_ID

BASE_DEMAND_ID

CUSTOMER_ID

CUSTOMER_SITE_ID

DEMAND_CLASS

DEMAND_CLASS_CODE

SELLING_PRICE

ORCH_ORDER_HEADER_ID

ORCH_ORDER_LINE_ID

CARRIER_ID

MODE_OF_TRANSPORT

RESERVATION_ID

RESERVED_QUANTITY

PLANNED_SHIP_DATE

ITEM

ITEM_DESCRIPTION

ORGANIZATION_ID

SCHEDULED_SHIP_FROM_ORG_ID

SHIP_MODEL_COMPLETE_FLAG

ORIGINAL_ITEM_ID

RECEIVING_ORG_ID

CONFIGURATION_ITEM

SUPPLIER_ID

SCHEDULED_SUPPLIER_ID

SUPPLIER_SITE_ID

SCHEDULED_SUPPLIER_SITE_ID

USING_REQUIREMENT_QUANTITY

SERVICE_LEVEL

LATEST_ACCEPTABLE_SHIP_DATE

LATEST_ACCEPTABLE_ARRIVAL_DATE

EARLIEST_ACCEPT_SHIP_DATE

EARLIEST_ACCEPT_ARRIVAL_DATE

ORDER_DATE_TYPE_CODE

SHIP_METHOD

REQUESTED_SHIP_METHOD

SCHEDULE_ARRIVAL_DATE

USING_ASSEMBLY_DEMAND_DATE

ZONE_ID

ROOT_FULFILLMENT_LINE

SHIP_SET_ID

SHIP_SET_NAME

ORIGINAL_SHIP_SET_ID

ORIGINAL_SHIP_SET_NAME

SET_TYPE

ORIGINAL_PRIORITY

SALES_ORDER_LINE_SPLIT

ISSUED_QUANTITY

FULFILLMENT_COST

SHIPPING_PREFERENCE

UOM_CODE

ORDERED_UOM

UOM_RATE

SALES_ORDER_NUMBER

SO_LINE_NUM

ORDER_NUMBER

LATEST_ACCEPTABLE_DATE

BOM_ITEM_TYPE

BOM_ITEM_TYPE_CODE

ITEM_SUB_TYPE_CODE

ORDER_TYPE_CODE

REQUEST_SHIP_DATE

SCHEDULE_SHIP_DATE

SALES_ORDER_LINE_ID

RESERVATION_STATUS_VALUE

ORDER_MARGIN

EARLIEST_ACCEPTABLE_DATE

PROMISED_ARRIVAL_DATE

PROMISED_SHIP_DATE

REQUESTED_ARRIVAL_DATE

SCHEDULED_ITEM

SCHEDULED_ITEM_DESCRIPTION

ORDER_LINE_NUMBER

CATEGORY_NAME

NAME_OF_CATEGORY

CATALOG_NAME

ORGANIZATION_NAME

ORGANIZATION

SCHEDULED_SHIP_FROM_WAREHOUSE

SCHEDULED_SHIP_FROM_WARE_NAME

ORDER_TYPE

REQUEST_DATE

SCHEDULE_DATE

DAYS_LATE

ORDER_REVENUE

ORIGINAL_ORG_ID

DEMAND_TYPE

USING_ASSEMBLY_ITEM_ID

ORIGINAL_QUANTITY

SOURCE_ORG_INSTANCE_ID

DEMAND_SOURCE_INSTANCE

ALLOW_SPLITS

ALLOW_SUBSTITUTION

FULFILLMENT_LINE_NUM

MIN_PERCENTAGE_FOR_SPLIT

MIN_QUANTITY_FOR_SPLIT

ORCH_ORDER_LINE_NUMBER

ORCH_ORDER_NUMBER

PROMISE_DATE

PROMISING_SYSTEM

COMPLETED_QUANTITY

DEMAND_SOURCE_TYPE

SOURCE_DOCUMENT_LINE_NUMBER

SOURCE_DOCUMENT_NUMBER

DEMAND_SOURCE_SYSTEM_ID

INVENTORY_ITEM_ID

CATEGORY_ID

CATEGORY_SET_ID

PARENT_FULFILLMENT_LINE

SET_PARENT_FULFILLMENT_LINE

FULFILLMENT_LINE

CUSTOMER_NAME

CUSTOMER_NUMBER

CUSTOMER_SHIP_SITE

REQUESTED_QUANTITY

SCHEDULED_QUANTITY

SCHEDULED_DROPSHIP_SUPPLIER

SCHEDULED_DROPSHIP_SUP_SITE

FULFILLMENT_MODE

SCHEDULED_CARRIER

SCHEDULED_DAYS_OF_DELAYS

SCHEDULED_MODE_OF_TRANSPORT

EXPECTED_MODE_OF_TRANSPORT

SCHEDULED_SERVICE_LEVEL

EXPECTED_SERVICE_LEVEL

RELEASE_STATUS

RELEASE_STATUS_ORIG

PLANNER_CODE

OBJECT_VERSION_NUMBER

SUPPLIER_SITE_SOURCE_SYSTEM_ID

SCHED_SUP_SITE_SYSTEM_ID

SCHED_SUP_SITE_SYSTEM

INTERNAL_ORDER_TYPE

LAST_UPDATED_BY

LAST_UPDATE_DATE

SET_HEADER_NAME

ROW_TYPE

OVERRIDE_PRIORITY

EXPECTED_DATE

REQUESTED_DATE

MODIFIED

CREATION_DATE

INQUIRY_DEMAND

EXPENSE_TRANSFER

SOURCE_DOC_ORDER_TYPE_STR

REMOVED_FROM_SET

ORDER_LINE_STATUS

CONSTRAINT_RANK

DAYS_POTENTIALLY_IMPROVE

PLANNED_DATE_WITHOUT_ITEM

SPLIT_INDICATOR

ORIG_PARENT_FUL_LINE

SUPPLY_PICK_DATE

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

ATTRIBUTE_DATE16

ATTRIBUTE_DATE17

ATTRIBUTE_DATE18

ATTRIBUTE_DATE19

ATTRIBUTE_DATE20

GLOBAL_ATTRIBUTE_CHAR1

GLOBAL_ATTRIBUTE_CHAR2

GLOBAL_ATTRIBUTE_CHAR3

GLOBAL_ATTRIBUTE_CHAR4

GLOBAL_ATTRIBUTE_CHAR5

GLOBAL_ATTRIBUTE_CHAR6

GLOBAL_ATTRIBUTE_CHAR7

GLOBAL_ATTRIBUTE_CHAR8

GLOBAL_ATTRIBUTE_CHAR9

GLOBAL_ATTRIBUTE_CHAR10

GLOBAL_ATTRIBUTE_CHAR11

GLOBAL_ATTRIBUTE_CHAR12

GLOBAL_ATTRIBUTE_CHAR13

GLOBAL_ATTRIBUTE_CHAR14

GLOBAL_ATTRIBUTE_CHAR15

GLOBAL_ATTRIBUTE_CHAR16

GLOBAL_ATTRIBUTE_CHAR17

GLOBAL_ATTRIBUTE_CHAR18

GLOBAL_ATTRIBUTE_CHAR19

GLOBAL_ATTRIBUTE_CHAR20

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

GLOBAL_ATTRIBUTE_NUMBER6

GLOBAL_ATTRIBUTE_NUMBER7

GLOBAL_ATTRIBUTE_NUMBER8

GLOBAL_ATTRIBUTE_NUMBER9

GLOBAL_ATTRIBUTE_NUMBER10

GLOBAL_ATTRIBUTE_NUMBER11

GLOBAL_ATTRIBUTE_NUMBER12

GLOBAL_ATTRIBUTE_NUMBER13

GLOBAL_ATTRIBUTE_NUMBER14

GLOBAL_ATTRIBUTE_NUMBER15

GLOBAL_ATTRIBUTE_NUMBER16

GLOBAL_ATTRIBUTE_NUMBER17

GLOBAL_ATTRIBUTE_NUMBER18

GLOBAL_ATTRIBUTE_NUMBER19

GLOBAL_ATTRIBUTE_NUMBER20

GLOBAL_ATTRIBUTE_NUMBER21

GLOBAL_ATTRIBUTE_NUMBER22

GLOBAL_ATTRIBUTE_NUMBER23

GLOBAL_ATTRIBUTE_NUMBER24

GLOBAL_ATTRIBUTE_NUMBER25

GLOBAL_ATTRIBUTE_NUMBER26

GLOBAL_ATTRIBUTE_NUMBER27

GLOBAL_ATTRIBUTE_NUMBER28

GLOBAL_ATTRIBUTE_NUMBER29

GLOBAL_ATTRIBUTE_NUMBER30

GLOBAL_ATTRIBUTE_NUMBER31

GLOBAL_ATTRIBUTE_NUMBER32

GLOBAL_ATTRIBUTE_NUMBER33

GLOBAL_ATTRIBUTE_NUMBER34

GLOBAL_ATTRIBUTE_NUMBER35

GLOBAL_ATTRIBUTE_NUMBER36

GLOBAL_ATTRIBUTE_NUMBER37

GLOBAL_ATTRIBUTE_NUMBER38

GLOBAL_ATTRIBUTE_NUMBER39

GLOBAL_ATTRIBUTE_NUMBER40

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_DATE6

GLOBAL_ATTRIBUTE_DATE7

GLOBAL_ATTRIBUTE_DATE8

GLOBAL_ATTRIBUTE_DATE9

GLOBAL_ATTRIBUTE_DATE10

GLOBAL_ATTRIBUTE_DATE11

GLOBAL_ATTRIBUTE_DATE12

GLOBAL_ATTRIBUTE_DATE13

GLOBAL_ATTRIBUTE_DATE14

GLOBAL_ATTRIBUTE_DATE15

GLOBAL_ATTRIBUTE_DATE16

GLOBAL_ATTRIBUTE_DATE17

GLOBAL_ATTRIBUTE_DATE18

GLOBAL_ATTRIBUTE_DATE19

GLOBAL_ATTRIBUTE_DATE20

GLOBAL_ATTRIBUTE_CHAR21

GLOBAL_ATTRIBUTE_CHAR22

GLOBAL_ATTRIBUTE_CHAR23

USER_DEF_PRIORITY

ORG_FOR_DRILL

Query

SQL_Statement

SELECT

BMDemandsEO.PLAN_ID as BM_RUN_ID,

BMDemandsEO.DEMAND_LEAD_TIME_DATE,

BMDemandsEO.USR_DEF_DMD_LEAD_TIME_DATE,

BMDemandsEO.DEMAND_FULFILLMENT_LEAD_TIME,

BMDemandsEO.REASON_CODE,

BMDemandsEO.DEMAND_PRIORITY,

BMDemandsEO.NEW_PROMISED_DATE,

BMDemandsEO.OLD_PROMISED_DATE,

BMDemandsEO.SOURCE_ORGANIZATION_ID,

BMDemandsEO.FIRM_SALES_ORDER,

BMDemandsEO.FIRM_SHIP_FROM_ORG,

BMDemandsEO.FIRM_SHIP_SET_NAME,

BMDemandsEO.FIRM_ARRIVAL_SET_NAME,

BMDemandsEO.EARLIEST_PROMISED_DATE,

BMDemandsEO.EXPECTED_SHIP_DATE,

BMDemandsEO.EXPECTED_ARRIVAL_DATE,

(

case

when decode(BMDemandsEO.supplier_id, null, BMDemandsEO.USING_ASSEMBLY_DEMAND_DATE, BMDemandsEO.SCHEDULE_SHIP_DATE) is null

and decode(BMDemandsEO.supplier_id, null, BMDemandsEO.SCHEDULE_ARRIVAL_DATE, BMDemandsEO.USING_ASSEMBLY_DEMAND_DATE) is null

then 2

else 1

end) AS Scheduling_Status_Code,

BMDemandsEO.ECC_FLAG,

BMDemandsEO.PULL_IN_FLAG,

BMDemandsEO.MANUAL_OVERRIDE_FLAG,

BMDemandsEO.EXPECTED_SHIP_METHOD as EXPECTED_SHIP_METHOD_ID,

BMDemandsEO.EXPECTED_CARRIER_ID as EXPECTED_CARRIER_ID,

BMDemandsEO.EXPECTED_SERVICE_LEVEL_ID,

BMDemandsEO.EXPECTED_SUPPLIER_ID as EXPECTED_SUPPLIER_ID,

BMDemandsEO.EXPECTED_MODE_OF_TRANSPORT_ID,

BMDemandsEO.EXPECTED_SUPPLIER_SITE_ID as EXPECTED_SUPPLIER_SITE_ID,

BMDemandsEO.SOURCE_ORGANIZATION_ID as EXPECTED_ORGANIZATION_ID,

(select msc_get_name.org_code(BMDemandsEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WAREHOUSE,

(select msc_get_name.org_name(BMDemandsEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WARE_NAME,

(select msc_get_name.supplier(BMDemandsEO.EXPECTED_SUPPLIER_ID) from dual) AS EXPECTED_DSHIP_SUPPLIER,

(select msc_get_name.supplier_site(BMDemandsEO.EXPECTED_SUPPLIER_SITE_ID) from dual) AS EXPECTED_DSHIP_SUPP_SITE,

null EXPECTED_CARRIER,

BMDemandsEO.DEMAND_ID,

BMDemandsEO.BASE_DEMAND_ID,

BMDemandsEO.CUSTOMER_ID,

BMDemandsEO.CUSTOMER_SITE_ID,

BMDemandsEO.DEMAND_CLASS,

(select msc_get_name.msc_sr_lookup_meaning(BMDemandsEO.DEMAND_CLASS, 'DEMAND_CLASS') from dual) AS DEMAND_CLASS_CODE,

BMDemandsEO.SELLING_PRICE,

BMDemandsEO.ORCH_ORDER_HEADER_ID,

BMDemandsEO.ORCH_ORDER_LINE_ID,

BMDemandsEO.CARRIER_ID,

BMDemandsEO.MODE_OF_TRANSPORT,

BMDemandsEO.RESERVATION_ID,

BMDemandsEO.RESERVED_QUANTITY,

null as PLANNED_SHIP_DATE,

ItemEO.ITEM_NAME AS ITEM,

ItemEO.DESCRIPTION AS ITEM_DESCRIPTION,

BMDemandsEO.ORGANIZATION_ID,

BMDemandsEO.SCHEDULED_SHIP_FROM_ORG_ID,

(select msc_bm_common.get_ship_model_complete_flag(BMDemandsEO.INVENTORY_ITEM_ID) from dual) AS SHIP_MODEL_COMPLETE_FLAG,

BMDemandsEO.ORIGINAL_ITEM_ID,

BMDemandsEO.RECEIVING_ORG_ID,

BMDemandsEO.CONFIGURATION_ITEM,

BMDemandsEO.SUPPLIER_ID,

BMDemandsEO.SUPPLIER_ID AS SCHEDULED_SUPPLIER_ID,

BMDemandsEO.SUPPLIER_SITE_ID,

BMDemandsEO.SUPPLIER_SITE_ID AS SCHEDULED_SUPPLIER_SITE_ID,

BMDemandsEO.USING_REQUIREMENT_QUANTITY,

BMDemandsEO.SERVICE_LEVEL,

BMDemandsEO.LATEST_ACCEPTABLE_SHIP_DATE,

BMDemandsEO.LATEST_ACCEPTABLE_ARRIVAL_DATE,

BMDemandsEO.EARLIEST_ACCEPT_SHIP_DATE,

BMDemandsEO.EARLIEST_ACCEPT_ARRIVAL_DATE,

BMDemandsEO.ORDER_DATE_TYPE_CODE,

BMDemandsEO.SHIP_METHOD,

BMDemandsEO.SHIP_METHOD AS REQUESTED_SHIP_METHOD,

BMDemandsEO.Schedule_Arrival_Date,

BMDemandsEO.USING_ASSEMBLY_DEMAND_DATE,

BMDemandsEO.ZONE_ID,

BMDemandsEO.ROOT_FULFILLMENT_LINE,

BMDemandsEO.SHIP_SET_ID,

BMDemandsEO.SHIP_SET_NAME,

BMDemandsEO.ORIGINAL_SHIP_SET_ID,

BMDemandsEO.ORIGINAL_SHIP_SET_NAME,

BMDemandsEO.SET_TYPE,

BMDemandsEO.ORIGINAL_PRIORITY,

BMDemandsEO.SALES_ORDER_LINE_SPLIT,

null as ISSUED_QUANTITY,

BMDemandsEO.FULFILLMENT_COST,

BMDemandsEO.SHIPPING_PREFERENCE,

msc_bm_common.get_unit_of_measure(BMDemandsEO.INVENTORY_ITEM_ID,BMDemandsEO.ORGANIZATION_ID) AS UOM_CODE,

BMDemandsEO.ORDERED_UOM,

BMDemandsEO.UOM_RATE,

BMDemandsEO.SALES_ORDER_NUMBER,

BMDemandsEO.SO_LINE_NUM,

BMDemandsEO.Order_Number,

BMDemandsEO.Latest_Acceptable_Date,

BMDemandsEO.BOM_ITEM_TYPE,

BMDemandsEO.Bom_item_type_code,

BMDemandsEO.Item_Sub_Type_code,

BMDemandsEO.Order_Type_Code,

DECODE (BMDemandsEO.order_date_type_code, 1, BMDemandsEO.request_date, NULL) AS Request_Ship_Date,

BMDemandsEO.Schedule_Ship_Date,

BMDemandsEO.Sales_Order_Line_Id,

CASE when (BMDemandsEO.RESERVED_QUANTITY is not null) then 1

else 2

END as RESERVATION_STATUS_VALUE,

BMDemandsEO.Order_Margin,

BMDemandsEO.Earliest_Acceptable_Date,

BMDemandsEO.Promised_Arrival_Date,

BMDemandsEO.Promised_Ship_Date,

DECODE (BMDemandsEO.order_date_type_code, 2, BMDemandsEO.request_date, NULL) AS Requested_Arrival_Date,

ItemEO.ITEM_NAME AS SCHEDULED_ITEM,

ItemEO.DESCRIPTION AS SCHEDULED_ITEM_DESCRIPTION,

BMDemandsEO.Order_Line_Number,

null as CATEGORY_NAME,

(select msc_bm_common.category_name(BMDemandsEO.inventory_item_id,BMDemandsEO.organization_id) from dual) AS NAME_OF_CATEGORY,

null as CATALOG_NAME,

orgs.organization_name AS ORGANIZATION_NAME,

orgs.organization_code AS ORGANIZATION,

(select msc_get_name.org_code(BMDemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WAREHOUSE,

(select msc_get_name.org_name(BMDemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WARE_NAME,

BMDemandsEO.Order_Type,

BMDemandsEO.REQUEST_DATE,

BMDemandsEO.Schedule_Date,

BMDemandsEO.days_late,

BMDemandsEO.Order_Revenue,

BMDemandsEO.ORIGINAL_ORG_ID,

BMDemandsEO.DEMAND_TYPE,

BMDemandsEO.USING_ASSEMBLY_ITEM_ID,

BMDemandsEO.ORIGINAL_QUANTITY,

BMDemandsEO.SOURCE_ORG_INSTANCE_ID,

BMDemandsEO.DEMAND_SOURCE_INSTANCE,

BMDemandsEO.ALLOW_SPLITS,

BMDemandsEO.ALLOW_SUBSTITUTION,

BMDemandsEO.FULFILLMENT_LINE_NUM,

BMDemandsEO.MIN_PERCENTAGE_FOR_SPLIT,

BMDemandsEO.MIN_QUANTITY_FOR_SPLIT,

BMDemandsEO.ORCH_ORDER_LINE_NUMBER,

BMDemandsEO.ORCH_ORDER_NUMBER,

BMDemandsEO.PROMISE_DATE,

BMDemandsEO.PROMISING_SYSTEM,

BMDemandsEO.COMPLETED_QUANTITY,

BMDemandsEO.DEMAND_SOURCE_TYPE,

BMDemandsEO.SOURCE_DOCUMENT_LINE_NUMBER,

BMDemandsEO.SOURCE_DOCUMENT_NUMBER,

BMDemandsEO.PART_KEY1 as DEMAND_SOURCE_SYSTEM_ID,

BMDemandsEO.INVENTORY_ITEM_ID,

null as CATEGORY_ID,

null as CATEGORY_SET_ID,

BMDemandsEO.PARENT_FULFILLMENT_LINE,

BMDemandsEO.SET_PARENT_FULFILLMENT_LINE,

BMDemandsEO.sales_order_line_id AS Fulfillment_line,

(select msc_get_name.customer(BMDemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NAME,

(select msc_get_name.customer_number(BMDemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NUMBER,

(select msc_get_name.customer_site(BMDemandsEO.CUSTOMER_SITE_ID) from dual) AS CUSTOMER_SHIP_SITE,

BMDemandsEO.REQUESTED_QUANTITY,

BMDemandsEO.SCHEDULED_QUANTITY,

(select msc_get_name.supplier(BMDemandsEO.SUPPLIER_ID) from dual) AS SCHEDULED_DROPSHIP_SUPPLIER,

(select msc_get_name.supplier_site(BMDemandsEO.SUPPLIER_SITE_ID) from dual) AS SCHEDULED_DROPSHIP_SUP_SITE,

BMDemandsEO.FULFILLMENT_MODE,

(select msc_get_name.carrier_name(BMDemandsEO.CARRIER_ID) from dual) AS SCHEDULED_CARRIER,

BMDemandsEO.Scheduled_days_of_Delays,

(select msc_get_name.msc_sr_lookup_meaning(BMDemandsEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS SCHEDULED_MODE_OF_TRANSPORT,

(select msc_get_name.msc_sr_lookup_meaning(BMDemandsEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS EXPECTED_MODE_OF_TRANSPORT,

(select msc_get_name.msc_sr_lookup_meaning(BMDemandsEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS SCHEDULED_SERVICE_LEVEL,

(select msc_get_name.msc_sr_lookup_meaning(BMDemandsEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS EXPECTED_SERVICE_LEVEL,

CASE

when (BMDemandsEO.MARKED_FOR_RELEASE = 1) then 14

else BMDemandsEO.release_status

END as release_status,

BMDemandsEO.release_status_orig,

(select MSC_SPUI_COMMON.planner_code(BMDemandsEO.INVENTORY_ITEM_ID,BMDemandsEO.ORGANIZATION_ID,-1) from dual) AS PLANNER_CODE,

1 AS Object_Version_Number,

BMDemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID,

BMDemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID AS SCHED_SUP_SITE_SYSTEM_ID,

(select msc_gopui_util.get_instance_code(BMDemandsEO.supplier_site_source_system_id) from dual) AS SCHED_SUP_SITE_SYSTEM,

BMDemandsEO.INTERNAL_ORDER_TYPE,

BMDemandsEO.LAST_UPDATED_BY,

BMDemandsEO.LAST_UPDATE_DATE,

BMDemandsEO.SET_HEADER_NAME as SET_HEADER_NAME,

2 as ROW_TYPE,

BMDemandsEO.OVERRIDE_PRIORITY,

DECODE( BMDemandsEO.ORDER_DATE_TYPE_CODE, 1, BMDemandsEO.EXPECTED_SHIP_DATE, 2, BMDemandsEO.EXPECTED_ARRIVAL_DATE, BMDemandsEO.EXPECTED_SHIP_DATE) AS EXPECTED_DATE,

null as REQUESTED_DATE,

null as MODIFIED,

BMDemandsEO.ORDERED_DATE as creation_Date,

nvl(BMDemandsEO.INQUIRY_DEMAND,2) AS INQUIRY_DEMAND,

BMDemandsEO.expense_transfer,

BMDemandsEO.SOURCE_DOC_ORDER_TYPE_STR,

BMDemandsEO.removed_from_set,

BMDemandsEO.order_line_status,

BMDemandsEO.CONSTRAINT_RANK,

BMDemandsEO.DAYS_POTENTIALLY_IMPROVE,

BMDemandsEO.PLANNED_DATE_WITHOUT_ITEM,

BMDemandsEO.SPLIT_INDICATOR,

BMDemandsEO.ORIG_PARENT_FUL_LINE,

BMDemandsEO.SUPPLY_PICK_DATE,

BMDemandsEO.ATTRIBUTE_CATEGORY,

BMDemandsEO.ATTRIBUTE_CHAR1,

BMDemandsEO.ATTRIBUTE_CHAR2,

BMDemandsEO.ATTRIBUTE_CHAR3,

BMDemandsEO.ATTRIBUTE_CHAR4,

BMDemandsEO.ATTRIBUTE_CHAR5,

BMDemandsEO.ATTRIBUTE_CHAR6,

BMDemandsEO.ATTRIBUTE_CHAR7,

BMDemandsEO.ATTRIBUTE_CHAR8,

BMDemandsEO.ATTRIBUTE_CHAR9,

BMDemandsEO.ATTRIBUTE_CHAR10,

BMDemandsEO.ATTRIBUTE_CHAR11,

BMDemandsEO.ATTRIBUTE_CHAR12,

BMDemandsEO.ATTRIBUTE_CHAR13,

BMDemandsEO.ATTRIBUTE_CHAR14,

BMDemandsEO.ATTRIBUTE_CHAR15,

BMDemandsEO.ATTRIBUTE_CHAR16,

BMDemandsEO.ATTRIBUTE_CHAR17,

BMDemandsEO.ATTRIBUTE_CHAR18,

BMDemandsEO.ATTRIBUTE_CHAR19,

BMDemandsEO.ATTRIBUTE_CHAR20,

BMDemandsEO.ATTRIBUTE_NUMBER1,

BMDemandsEO.ATTRIBUTE_NUMBER2,

BMDemandsEO.ATTRIBUTE_NUMBER3,

BMDemandsEO.ATTRIBUTE_NUMBER4,

BMDemandsEO.ATTRIBUTE_NUMBER5,

BMDemandsEO.ATTRIBUTE_NUMBER6,

BMDemandsEO.ATTRIBUTE_NUMBER7,

BMDemandsEO.ATTRIBUTE_NUMBER8,

BMDemandsEO.ATTRIBUTE_NUMBER9,

BMDemandsEO.ATTRIBUTE_NUMBER10,

BMDemandsEO.ATTRIBUTE_DATE1,

BMDemandsEO.ATTRIBUTE_DATE2,

BMDemandsEO.ATTRIBUTE_DATE3,

BMDemandsEO.ATTRIBUTE_DATE4,

BMDemandsEO.ATTRIBUTE_DATE5,

BMDemandsEO.ATTRIBUTE_DATE6,

BMDemandsEO.ATTRIBUTE_DATE7,

BMDemandsEO.ATTRIBUTE_DATE8,

BMDemandsEO.ATTRIBUTE_DATE9,

BMDemandsEO.ATTRIBUTE_DATE10,

BMDemandsEO.ATTRIBUTE_DATE11,

BMDemandsEO.ATTRIBUTE_DATE12,

BMDemandsEO.ATTRIBUTE_DATE13,

BMDemandsEO.ATTRIBUTE_DATE14,

BMDemandsEO.ATTRIBUTE_DATE15,

BMDemandsEO.ATTRIBUTE_DATE16,

BMDemandsEO.ATTRIBUTE_DATE17,

BMDemandsEO.ATTRIBUTE_DATE18,

BMDemandsEO.ATTRIBUTE_DATE19,

BMDemandsEO.ATTRIBUTE_DATE20,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR1,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR2,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR3,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR4,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR5,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR6,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR7,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR8,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR9,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR10,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR11,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR12,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR13,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR14,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR15,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR16,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR17,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR18,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR19,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR20,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER1,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER2,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER3,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER4,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER5,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER6,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER7,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER8,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER9,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER10,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER11,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER12,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER13,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER14,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER15,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER16,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER17,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER18,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER19,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER20,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER21,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER22,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER23,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER24,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER25,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER26,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER27,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER28,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER29,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER30,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER31,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER32,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER33,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER34,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER35,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER36,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER37,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER38,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER39,

BMDemandsEO.GLOBAL_ATTRIBUTE_NUMBER40,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE1,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE2,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE3,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE4,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE5,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE6,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE7,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE8,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE9,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE10,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE11,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE12,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE13,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE14,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE15,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE16,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE17,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE18,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE19,

BMDemandsEO.GLOBAL_ATTRIBUTE_DATE20,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR21,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR22,

BMDemandsEO.GLOBAL_ATTRIBUTE_CHAR23,

BMDemandsEO.USER_DEFINED_PRIORITY as USER_DEF_PRIORITY,

nvl(BMDemandsEO.SOURCE_ORGANIZATION_ID,BMDemandsEO.SCHEDULED_SHIP_FROM_ORG_ID) as ORG_FOR_DRILL

FROM MSC_BM_DEMANDS BMDemandsEO,

MSC_ITEMS ItemEO,

msc_parameters orgs

where

ItemEO.Inventory_item_id = BMDemandsEO.Inventory_item_id

AND orgs.organization_id(+) = BMDemandsEO.organization_id