1. Tables and Views for SCM
  2. MSC_BM_DEMANDS_V

MSC_BM_DEMANDS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ALLOW_SPLITS_CODE

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR20

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_DATE1

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

ATTRIBUTE_DATE16

ATTRIBUTE_DATE17

ATTRIBUTE_DATE18

ATTRIBUTE_DATE19

ATTRIBUTE_DATE2

ATTRIBUTE_DATE20

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

BASE_DEMAND_ID

BM_RUN_ID

ITEM_TYPE

ITEM_TYPE_CODE

REQUESTED_CARRIER_ID

CATALOG_NAME

CATEGORY_ID

CATEGORY_SET_ID

COMPLETED_QUANTITY

CONFIGURATION_ITEM_ID

CONSTRAINT_RANK

CREATION_DATE

CUSTOMER_ID

CUSTOMER_NAME

CUSTOMER_SHIP_SITE

CUSTOMER_SITE_ID

DAYS_LATE

DAYS_POTENTIALLY_IMPROVE

DEMAND_CLASS

DEMAND_CLASS_CODE

DEMAND_FULFILLMENT_LEAD_TIME

DEMAND_ID

DEMAND_LEAD_TIME_DATE

DEMAND_PRIORITY

DEMAND_SOURCE_INSTANCE

DEMAND_SOURCE_SYSTEM_ID

DEMAND_SOURCE_TYPE

EARLIEST_ACCEPT_ARRIVAL_DATE

EARLIEST_ACCEPT_SHIP_DATE

EARLIEST_ACCEPTABLE_DATE

EARLIEST_PROMISED_DATE

ENFORCE_CURRENT_COMMIT_CODE

EXPECTED_ARRIVAL_DATE

EXPECTED_CARRIER

EXPECTED_CARRIER_ID

SCHEDULED_CARRIER_ID

EXPECTED_DATE

EXPECTED_DSHIP_SUPP_SITE

EXPECTED_DSHIP_SUPPLIER

EXPECTED_MODE_OF_TRANSPORT

EXPECTED_MODE_OF_TRANSPORT_ID

SCHEDULED_MODE_OF_TRANSPORT_ID

EXPECTED_ORGANIZATION_ID

EXPECTED_SERVICE_LEVEL

EXPECTED_SERVICE_LEVEL_ID

SCHEDULED_SERVICE_LEVEL_ID

EXPECTED_SHIP_DATE

EXPECTED_SHIP_FROM_WARE_NAME

EXPECTED_SHIP_FROM_WAREHOUSE

EXPECTED_SHIP_METHOD_ID

REQUESTED_SHIP_METHOD_ID

SCHEDULED_SHIP_METHOD_ID

EXPECTED_SUPPLIER_ID

EXPECTED_SUPPLIER_SITE_ID

FIRM_SALES_ORDER_CODE

FULFILLMENT_COST_ORIGINAL

FULFILLMENT_LINE

FULFILLMENT_LINE_NUMBER

FULFILLMENT_MODE

GLOBAL_ATTRIBUTE_CHAR1

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_CHAR2

GLOBAL_ATTRIBUTE_CHAR20

GLOBAL_ATTRIBUTE_CHAR21

GLOBAL_ATTRIBUTE_CHAR22

GLOBAL_ATTRIBUTE_CHAR23

GLOBAL_ATTRIBUTE_CHAR3

GLOBAL_ATTRIBUTE_CHAR4

GLOBAL_ATTRIBUTE_CHAR5

GLOBAL_ATTRIBUTE_CHAR6

GLOBAL_ATTRIBUTE_CHAR7

GLOBAL_ATTRIBUTE_CHAR8

GLOBAL_ATTRIBUTE_CHAR9

GLOBAL_ATTRIBUTE_DATE1

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_DATE2

GLOBAL_ATTRIBUTE_DATE20

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_DATE6

GLOBAL_ATTRIBUTE_DATE7

GLOBAL_ATTRIBUTE_DATE8

GLOBAL_ATTRIBUTE_DATE9

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER10

PROJECT

TASK

GLOBAL_ATTRIBUTE_NUMBER13

GLOBAL_ATTRIBUTE_NUMBER14

GLOBAL_ATTRIBUTE_NUMBER15

GLOBAL_ATTRIBUTE_NUMBER16

GLOBAL_ATTRIBUTE_NUMBER17

GLOBAL_ATTRIBUTE_NUMBER18

GLOBAL_ATTRIBUTE_NUMBER19

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER20

GLOBAL_ATTRIBUTE_NUMBER21

GLOBAL_ATTRIBUTE_NUMBER22

GLOBAL_ATTRIBUTE_NUMBER23

GLOBAL_ATTRIBUTE_NUMBER24

GLOBAL_ATTRIBUTE_NUMBER25

PROJECT_GROUP

GLOBAL_ATTRIBUTE_NUMBER27

GLOBAL_ATTRIBUTE_NUMBER28

GLOBAL_ATTRIBUTE_NUMBER29

GLOBAL_ATTRIBUTE_NUMBER3

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_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER40

GLOBAL_ATTRIBUTE_NUMBER5

GLOBAL_ATTRIBUTE_NUMBER6

GLOBAL_ATTRIBUTE_NUMBER7

GLOBAL_ATTRIBUTE_NUMBER8

GLOBAL_ATTRIBUTE_NUMBER9

INQUIRY_DEMAND

INVENTORY_ITEM_ID

ITEM

ITEM_DESCRIPTION

ITEM_SUB_TYPE_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LATEST_ACCEPTABLE_ARRIVAL_DATE

LATEST_ACCEPTABLE_DATE

LATEST_ACCEPTABLE_SHIP_DATE

MANUAL_OVERRIDE_CODE

MIN_PERCENTAGE_FOR_SPLIT

MIN_QUANTITY_FOR_SPLIT

REQUESTED_MODE_OF_TRANSPORT_ID

MODIFIED

NAME_OF_CATEGORY

NEW_PROMISED_DATE

OBJECT_VERSION_NUMBER

OLD_PROMISED_DATE

ORCH_ORDER_HEADER_ID

ORCH_ORDER_LINE_ID

ORCH_ORDER_LINE_NUMBER

ORCH_ORDER_NUMBER

ORDER_DATE_TYPE_CODE

ORDER_LINE_NUMBER

ORDER_LINE_STATUS_CODE

ORDER_MARGIN_ORIGINAL

ORDER_NUMBER

ORDER_REVENUE_ORIGINAL

ORDER_TYPE

ORDER_TYPE_CODE

ORDERED_UOM

REQUESTED_ORGANIZATION

REQUESTED_ORGANIZATION_ID

REQUESTED_ORGANIZATION_NAME

ORIG_PARENT_FUL_LINE

ORIGINAL_QUANTITY

ORIGINAL_SHIP_SET_NAME

OVERRIDE_PRIORITY

PARENT_FULFILLMENT_LINE

PLANNED_DATE_WITHOUT_ITEM

PLANNED_SHIP_DATE

PLANNER_CODE

PROMISE_DATE

PROMISED_ARRIVAL_DATE

PROMISED_SHIP_DATE

PULL_IN_CODE

REASON_CODE

RECEIVING_ORG_ID

RELEASE_STATUS

REMOVED_FROM_SET

REQUEST_DATE

REQUEST_SHIP_DATE

REQUESTED_ARRIVAL_DATE

REQUESTED_QUANTITY

RESERVATION_STATUS_VALUE

RESERVED_QUANTITY

ROOT_FULFILLMENT_LINE

SALES_ORDER_LINE_ID

SALES_ORDER_LINE_SPLIT

SALES_ORDER_NUMBER

SCHED_SUP_SITE_SYSTEM

SCHED_SUP_SITE_SYSTEM_ID

SCHEDULE_ARRIVAL_DATE

SCHEDULE_DATE

SCHEDULE_SHIP_DATE

SCHEDULED_CARRIER

SCHEDULED_DAYS_OF_DELAYS

SCHEDULED_DROPSHIP_SUP_SITE

SCHEDULED_DROPSHIP_SUPPLIER

SCHEDULED_ITEM

SCHEDULED_ITEM_DESCRIPTION

SCHEDULED_MODE_OF_TRANSPORT

SCHEDULED_QUANTITY

SCHEDULED_SERVICE_LEVEL

SCHEDULED_SHIP_FROM_ORG_ID

SCHEDULED_SHIP_FROM_WARE_NAME

SCHEDULED_SHIP_FROM_WAREHOUSE

SCHEDULED_SUPPLIER_ID

SCHEDULED_SUPPLIER_SITE_ID

SCHEDULING_STATUS_CODE

SELLING_PRICE_ORIGINAL

REQUESTED_SERVICE_LEVEL_ID

SET_HEADER_NAME

SET_PARENT_FULFILLMENT_LINE

SET_TYPE_CODE

SET_NAME

SO_LINE_NUMBER

SOURCE_DOCUMENT_ORDER_TYPE

SOURCE_DOCUMENT_LINE_NUMBER

SOURCE_DOCUMENT_NUMBER

SOURCE_ORG_INSTANCE_ID

SOURCE_ORGANIZATION_ID

SPLIT_INDICATOR

REQUESTED_SUPPLIER_ID

REQUESTED_SUPPLIER_SITE_ID

SUPPLIER_SITE_SOURCE_SYSTEM_ID

SUPPLY_PICK_DATE

UOM_CODE

UOM_RATE

USER_DEFINED_PRIORITY

USING_ASSEMBLY_DEMAND_DATE

USING_ASSEMBLY_ITEM_ID

USING_REQUIREMENT_QUANTITY

USR_DEF_DMD_LEAD_TIME_DATE

ZONE_ID

MARKED_FOR_RELEASE

SIMULATED_DAYS_OF_DELAY

DAYS_OF_IMPROVEMENT

DESTINATION_TIME_ZONE

SOURCE_TIME_ZONE

ORG_TIME_ZONE

REQUESTED_DROP_SHIP_SUPPLIER

REQUESTED_DSHIP_SUPPLIER_SITE

RESERVED_SUPPLY_DOCUMENT_NUMBER

RESERVED_SUPPLY_DOCUMENT_TYPE

PLANNED_DATE

AVAILABLE_QUANTITY

AVAILABLE_ITEM

REQUESTED_CARRIER

REQUESTED_SERVICE_LEVEL

REQUESTED_MODE_OF_TRANSPORT

REQUESTED_SHIP_METHOD

SCHEDULED_SHIP_METHOD

EXPECTED_SHIP_METHOD

ITEM_SUB_TYPE

RATE

ORDER_REVENUE

ORDER_MARGIN

SELLING_PRICE

FULFILLMENT_COST

ERROR_TEXT

INTERNAL_ORDER_TYPE

SCHEDULING_STATUS

RESERVATION_STATUS

REQUEST_TYPE

FIRM_SALES_ORDER

MANUAL_OVERRIDE

SIMULATION_DEMAND

ENFORCE_CURRENT_COMMIT

PULL_IN

SET_TYPE

ALLOW_SPLITS

ORDER_LINE_STATUS

SHIP_TO_ZONE

SHIP_TO_ORGANIZATION

SHIP_TO_ORGANIZATION_NAME

SUPPLIER_SITE_SOURCE_SYSTEM

CONFIGURATION_ITEM

DESTINATION_TYPE

SCHEDULED_QUANTITY_UOM

PROMISING_SYSTEM

RELEASE_STATUS_MEANING

PLANNING_ATTR_VAL_11

PLANNING_ATTR_VAL_12

PLANNING_ATTR_VAL_13

PLANNING_ATTR_VAL_14

PLANNING_ATTR_VAL_15

PLANNING_ATTR_VAL_16

PLANNING_ATTR_VAL_17

PLANNING_ATTR_VAL_18

PLANNING_ATTR_VAL_19

PLANNING_ATTR_VAL_20

PLANNING_ATTR_VAL_21

PLANNING_ATTR_VAL_22

PLANNING_ATTR_VAL_23

PLANNING_ATTR_VAL_24

PLANNING_ATTR_VAL_25

PLANNING_ATTR_VAL_26

ORIGINAL_SET_TYPE

DISPLAY_ATTRIBUTE_CODE

Query

SQL_Statement

SELECT MscBacklogAnalysisEO.ALLOW_SPLITS ALLOW_SPLITS_CODE,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR1,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR10,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR11,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR12,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR13,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR14,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR15,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR16,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR17,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR18,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR19,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR2,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR20,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR3,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR4,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR5,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR6,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR7,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR8,

MscBacklogAnalysisEO.ATTRIBUTE_CHAR9,

MscBacklogAnalysisEO.ATTRIBUTE_DATE1,

MscBacklogAnalysisEO.ATTRIBUTE_DATE10,

MscBacklogAnalysisEO.ATTRIBUTE_DATE11,

MscBacklogAnalysisEO.ATTRIBUTE_DATE12,

MscBacklogAnalysisEO.ATTRIBUTE_DATE13,

MscBacklogAnalysisEO.ATTRIBUTE_DATE14,

MscBacklogAnalysisEO.ATTRIBUTE_DATE15,

MscBacklogAnalysisEO.ATTRIBUTE_DATE16,

MscBacklogAnalysisEO.ATTRIBUTE_DATE17,

MscBacklogAnalysisEO.ATTRIBUTE_DATE18,

MscBacklogAnalysisEO.ATTRIBUTE_DATE19,

MscBacklogAnalysisEO.ATTRIBUTE_DATE2,

MscBacklogAnalysisEO.ATTRIBUTE_DATE20,

MscBacklogAnalysisEO.ATTRIBUTE_DATE3,

MscBacklogAnalysisEO.ATTRIBUTE_DATE4,

MscBacklogAnalysisEO.ATTRIBUTE_DATE5,

MscBacklogAnalysisEO.ATTRIBUTE_DATE6,

MscBacklogAnalysisEO.ATTRIBUTE_DATE7,

MscBacklogAnalysisEO.ATTRIBUTE_DATE8,

MscBacklogAnalysisEO.ATTRIBUTE_DATE9,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER1,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER10,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER2,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER3,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER4,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER5,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER6,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER7,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER8,

MscBacklogAnalysisEO.ATTRIBUTE_NUMBER9,

MscBacklogAnalysisEO.BASE_DEMAND_ID,

MscBacklogAnalysisEO.BM_RUN_ID,

MscBacklogAnalysisEO.BOM_ITEM_TYPE ITEM_TYPE,

MscBacklogAnalysisEO.BOM_ITEM_TYPE_CODE ITEM_TYPE_CODE,

MscBacklogAnalysisEO.CARRIER_ID REQUESTED_CARRIER_ID,

MscBacklogAnalysisEO.CATALOG_NAME,

MscBacklogAnalysisEO.CATEGORY_ID,

MscBacklogAnalysisEO.CATEGORY_SET_ID,

MscBacklogAnalysisEO.COMPLETED_QUANTITY,

MscBacklogAnalysisEO.CONFIGURATION_ITEM CONFIGURATION_ITEM_ID,

MscBacklogAnalysisEO.CONSTRAINT_RANK,

MscBacklogAnalysisEO.CREATION_DATE,

MscBacklogAnalysisEO.CUSTOMER_ID,

MscBacklogAnalysisEO.CUSTOMER_NAME,

MscBacklogAnalysisEO.CUSTOMER_SHIP_SITE,

MscBacklogAnalysisEO.CUSTOMER_SITE_ID,

MscBacklogAnalysisEO.DAYS_LATE,

MscBacklogAnalysisEO.DAYS_POTENTIALLY_IMPROVE,

MscBacklogAnalysisEO.DEMAND_CLASS,

MscBacklogAnalysisEO.DEMAND_CLASS_CODE,

MscBacklogAnalysisEO.DEMAND_FULFILLMENT_LEAD_TIME,

MscBacklogAnalysisEO.DEMAND_ID,

MscBacklogAnalysisEO.DEMAND_LEAD_TIME_DATE,

MscBacklogAnalysisEO.DEMAND_PRIORITY,

MscBacklogAnalysisEO.DEMAND_SOURCE_INSTANCE,

MscBacklogAnalysisEO.DEMAND_SOURCE_SYSTEM_ID,

MscBacklogAnalysisEO.DEMAND_SOURCE_TYPE,

MscBacklogAnalysisEO.EARLIEST_ACCEPT_ARRIVAL_DATE,

MscBacklogAnalysisEO.EARLIEST_ACCEPT_SHIP_DATE,

MscBacklogAnalysisEO.EARLIEST_ACCEPTABLE_DATE,

MscBacklogAnalysisEO.EARLIEST_PROMISED_DATE,

MscBacklogAnalysisEO.ECC_FLAG Enforce_Current_Commit_Code,

MscBacklogAnalysisEO.EXPECTED_ARRIVAL_DATE,

(select msc_get_name.carrier_name(MscBacklogAnalysisEO.EXPECTED_CARRIER_ID) from dual) EXPECTED_CARRIER,

MscBacklogAnalysisEO.EXPECTED_CARRIER_ID,

MscBacklogAnalysisEO.SCHEDULED_CARRIER_ID,

MscBacklogAnalysisEO.EXPECTED_DATE,

MscBacklogAnalysisEO.EXPECTED_DSHIP_SUPP_SITE,

MscBacklogAnalysisEO.EXPECTED_DSHIP_SUPPLIER,

MscBacklogAnalysisEO.EXPECTED_MODE_OF_TRANSPORT,

MscBacklogAnalysisEO.EXPECTED_MODE_OF_TRANSPORT_ID,

MscBacklogAnalysisEO.SCHEDULED_MODE_OF_TRANSPORT_ID,

MscBacklogAnalysisEO.EXPECTED_ORGANIZATION_ID,

MscBacklogAnalysisEO.EXPECTED_SERVICE_LEVEL,

MscBacklogAnalysisEO.EXPECTED_SERVICE_LEVEL_ID,

MscBacklogAnalysisEO.SCHEDULED_SERVICE_LEVEL_ID,

MscBacklogAnalysisEO.EXPECTED_SHIP_DATE,

MscBacklogAnalysisEO.EXPECTED_SHIP_FROM_WARE_NAME,

MscBacklogAnalysisEO.EXPECTED_SHIP_FROM_WAREHOUSE,

MscBacklogAnalysisEO.EXPECTED_SHIP_METHOD_ID,

MscBacklogAnalysisEO.REQUESTED_SHIP_METHOD REQUESTED_SHIP_METHOD_ID,

MscBacklogAnalysisEO.SCHEDULED_SHIP_METHOD SCHEDULED_SHIP_METHOD_ID,

MscBacklogAnalysisEO.EXPECTED_SUPPLIER_ID,

MscBacklogAnalysisEO.EXPECTED_SUPPLIER_SITE_ID,

MscBacklogAnalysisEO.FIRM_SALES_ORDER FIRM_SALES_ORDER_CODE,

MscBacklogAnalysisEO.FULFILLMENT_COST FULFILLMENT_COST_ORIGINAL,

MscBacklogAnalysisEO.FULFILLMENT_LINE,

MscBacklogAnalysisEO.FULFILLMENT_LINE_NUM FULFILLMENT_LINE_NUMBER,

MscBacklogAnalysisEO.FULFILLMENT_MODE,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR1,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR10,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR11,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR12,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR13,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR14,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR15,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR16,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR17,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR18,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR19,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR2,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR20,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR21,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR22,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR23,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR3,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR4,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR5,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR6,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR7,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR8,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR9,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE1,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE10,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE11,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE12,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE13,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE14,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE15,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE16,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE17,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE18,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE19,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE2,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE20,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE3,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE4,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE5,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE6,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE7,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE8,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_DATE9,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER1,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER10,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER11 PROJECT,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER12 TASK,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER13,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER14,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER15,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER16,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER17,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER18,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER19,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER2,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER20,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER21,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER22,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER23,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER24,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER25,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER26 PROJECT_GROUP,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER27,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER28,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER29,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER3,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER30,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER31,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER32,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER33,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER34,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER35,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER36,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER37,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER38,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER39,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER4,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER40,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER5,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER6,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER7,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER8,

MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER9,

MscBacklogAnalysisEO.INQUIRY_DEMAND,

MscBacklogAnalysisEO.INVENTORY_ITEM_ID,

MscBacklogAnalysisEO.ITEM,

MscBacklogAnalysisEO.ITEM_DESCRIPTION,

MscBacklogAnalysisEO.ITEM_SUB_TYPE_CODE,

MscBacklogAnalysisEO.LAST_UPDATE_DATE,

MscBacklogAnalysisEO.LAST_UPDATED_BY,

MscBacklogAnalysisEO.LATEST_ACCEPTABLE_ARRIVAL_DATE,

MscBacklogAnalysisEO.LATEST_ACCEPTABLE_DATE,

MscBacklogAnalysisEO.LATEST_ACCEPTABLE_SHIP_DATE,

MscBacklogAnalysisEO.MANUAL_OVERRIDE_FLAG MANUAL_OVERRIDE_CODE,

MscBacklogAnalysisEO.MIN_PERCENTAGE_FOR_SPLIT,

MscBacklogAnalysisEO.MIN_QUANTITY_FOR_SPLIT,

MscBacklogAnalysisEO.MODE_OF_TRANSPORT REQUESTED_MODE_OF_TRANSPORT_ID,

MscBacklogAnalysisEO.MODIFIED,

MscBacklogAnalysisEO.NAME_OF_CATEGORY,

MscBacklogAnalysisEO.NEW_PROMISED_DATE,

MscBacklogAnalysisEO.OBJECT_VERSION_NUMBER,

MscBacklogAnalysisEO.OLD_PROMISED_DATE,

MscBacklogAnalysisEO.ORCH_ORDER_HEADER_ID,

MscBacklogAnalysisEO.ORCH_ORDER_LINE_ID,

MscBacklogAnalysisEO.ORCH_ORDER_LINE_NUMBER,

MscBacklogAnalysisEO.ORCH_ORDER_NUMBER,

MscBacklogAnalysisEO.ORDER_DATE_TYPE_CODE,

MscBacklogAnalysisEO.ORDER_LINE_NUMBER,

MscBacklogAnalysisEO.ORDER_LINE_STATUS ORDER_LINE_STATUS_CODE,

MscBacklogAnalysisEO.ORDER_MARGIN ORDER_MARGIN_ORIGINAL,

MscBacklogAnalysisEO.ORDER_NUMBER,

MscBacklogAnalysisEO.ORDER_REVENUE ORDER_REVENUE_ORIGINAL,

MscBacklogAnalysisEO.ORDER_TYPE,

MscBacklogAnalysisEO.ORDER_TYPE_CODE,

MscBacklogAnalysisEO.ORDERED_UOM ORDERED_UOM,

MscBacklogAnalysisEO.ORGANIZATION REQUESTED_ORGANIZATION,

MscBacklogAnalysisEO.ORGANIZATION_ID REQUESTED_ORGANIZATION_ID ,

MscBacklogAnalysisEO.ORGANIZATION_NAME REQUESTED_ORGANIZATION_NAME,

MscBacklogAnalysisEO.ORIG_PARENT_FUL_LINE,

MscBacklogAnalysisEO.ORIGINAL_QUANTITY,

MscBacklogAnalysisEO.ORIGINAL_SHIP_SET_NAME,

MscBacklogAnalysisEO.OVERRIDE_PRIORITY,

MscBacklogAnalysisEO.PARENT_FULFILLMENT_LINE,

MscBacklogAnalysisEO.PLANNED_DATE_WITHOUT_ITEM,

MscBacklogAnalysisEO.PLANNED_SHIP_DATE,

MscBacklogAnalysisEO.PLANNER_CODE,

MscBacklogAnalysisEO.PROMISE_DATE,

MscBacklogAnalysisEO.PROMISED_ARRIVAL_DATE,

MscBacklogAnalysisEO.PROMISED_SHIP_DATE,

MscBacklogAnalysisEO.PULL_IN_FLAG PULL_IN_CODE,

MscBacklogAnalysisEO.REASON_CODE,

MscBacklogAnalysisEO.RECEIVING_ORG_ID,

MscBacklogAnalysisEO.RELEASE_STATUS,

MscBacklogAnalysisEO.REMOVED_FROM_SET,

MscBacklogAnalysisEO.REQUEST_DATE,

MscBacklogAnalysisEO.REQUEST_SHIP_DATE,

MscBacklogAnalysisEO.REQUESTED_ARRIVAL_DATE,

MscBacklogAnalysisEO.REQUESTED_QUANTITY,

MscBacklogAnalysisEO.RESERVATION_STATUS_VALUE,

MscBacklogAnalysisEO.RESERVED_QUANTITY,

MscBacklogAnalysisEO.ROOT_FULFILLMENT_LINE,

MscBacklogAnalysisEO.SALES_ORDER_LINE_ID,

MscBacklogAnalysisEO.SALES_ORDER_LINE_SPLIT,

MscBacklogAnalysisEO.SALES_ORDER_NUMBER,

MscBacklogAnalysisEO.SCHED_SUP_SITE_SYSTEM,

MscBacklogAnalysisEO.SCHED_SUP_SITE_SYSTEM_ID,

MscBacklogAnalysisEO.SCHEDULE_ARRIVAL_DATE,

MscBacklogAnalysisEO.SCHEDULE_DATE,

MscBacklogAnalysisEO.SCHEDULE_SHIP_DATE,

MscBacklogAnalysisEO.SCHEDULED_CARRIER,

MscBacklogAnalysisEO.SCHEDULED_DAYS_OF_DELAYS,

MscBacklogAnalysisEO.SCHEDULED_DROPSHIP_SUP_SITE,

MscBacklogAnalysisEO.SCHEDULED_DROPSHIP_SUPPLIER,

MscBacklogAnalysisEO.SCHEDULED_ITEM,

MscBacklogAnalysisEO.SCHEDULED_ITEM_DESCRIPTION,

MscBacklogAnalysisEO.SCHEDULED_MODE_OF_TRANSPORT,

MscBacklogAnalysisEO.SCHEDULED_QUANTITY,

MscBacklogAnalysisEO.SCHEDULED_SERVICE_LEVEL,

MscBacklogAnalysisEO.SCHEDULED_SHIP_FROM_ORG_ID,

MscBacklogAnalysisEO.SCHEDULED_SHIP_FROM_WARE_NAME,

MscBacklogAnalysisEO.SCHEDULED_SHIP_FROM_WAREHOUSE,

MscBacklogAnalysisEO.SCHEDULED_SUPPLIER_ID,

MscBacklogAnalysisEO.SCHEDULED_SUPPLIER_SITE_ID,

MscBacklogAnalysisEO.SCHEDULING_STATUS_CODE,

MscBacklogAnalysisEO.SELLING_PRICE SELLING_PRICE_ORIGINAL,

MscBacklogAnalysisEO.SERVICE_LEVEL REQUESTED_SERVICE_LEVEL_ID,

MscBacklogAnalysisEO.SET_HEADER_NAME,

MscBacklogAnalysisEO.SET_PARENT_FULFILLMENT_LINE,

MscBacklogAnalysisEO.SET_TYPE SET_TYPE_CODE,

MscBacklogAnalysisEO.SHIP_SET_NAME SET_NAME,

MscBacklogAnalysisEO.SO_LINE_NUM SO_LINE_NUMBER,

MscBacklogAnalysisEO.SOURCE_DOC_ORDER_TYPE_STR SOURCE_DOCUMENT_ORDER_TYPE,

MscBacklogAnalysisEO.SOURCE_DOCUMENT_LINE_NUMBER,

MscBacklogAnalysisEO.SOURCE_DOCUMENT_NUMBER,

MscBacklogAnalysisEO.SOURCE_ORG_INSTANCE_ID,

MscBacklogAnalysisEO.SOURCE_ORGANIZATION_ID,

MscBacklogAnalysisEO.SPLIT_INDICATOR,

MscBacklogAnalysisEO.SUPPLIER_ID REQUESTED_SUPPLIER_ID,

MscBacklogAnalysisEO.SUPPLIER_SITE_ID REQUESTED_SUPPLIER_SITE_ID,

MscBacklogAnalysisEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID,

MscBacklogAnalysisEO.SUPPLY_PICK_DATE,

MscBacklogAnalysisEO.UOM_CODE UOM_CODE,

MscBacklogAnalysisEO.UOM_RATE UOM_RATE,

MscBacklogAnalysisEO.USER_DEF_PRIORITY USER_DEFINED_PRIORITY ,

MscBacklogAnalysisEO.USING_ASSEMBLY_DEMAND_DATE,

MscBacklogAnalysisEO.USING_ASSEMBLY_ITEM_ID,

MscBacklogAnalysisEO.USING_REQUIREMENT_QUANTITY,

MscBacklogAnalysisEO.USR_DEF_DMD_LEAD_TIME_DATE,

MscBacklogAnalysisEO.ZONE_ID,

MscBacklogAnalysisEO.MARKED_FOR_RELEASE,

(

CASE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =1)

THEN MscBacklogAnalysisEO.EXPECTED_SHIP_DATE-MscBacklogAnalysisEO.REQUEST_DATE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =2)

then MscBacklogAnalysisEO.EXPECTED_ARRIVAL_DATE-MscBacklogAnalysisEO.REQUEST_DATE

END) Simulated_Days_Of_Delay,

(

CASE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =1)

THEN MscBacklogAnalysisEO.SCHEDULE_DATE - MscBacklogAnalysisEO.EXPECTED_SHIP_DATE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =2)

THEN MscBacklogAnalysisEO.SCHEDULE_DATE - MscBacklogAnalysisEO.EXPECTED_ARRIVAL_DATE

END) DAYS_OF_IMPROVEMENT,

(select msc_get_name.get_destination_timezone_name(1030, MscBacklogAnalysisEO.organization_id, null, MscBacklogAnalysisEO.customer_site_id) from dual) DESTINATION_TIME_ZONE,

(select msc_get_name.get_source_timezone_name(1030, MscBacklogAnalysisEO.organization_id, null, MscBacklogAnalysisEO.supplier_site_id) from dual) SOURCE_TIME_ZONE,

(select msc_get_name.get_timezone_name(MscBacklogAnalysisEO.organization_id) from dual) ORG_TIME_ZONE,

(select msc_get_name.supplier(MscBacklogAnalysisEO.SUPPLIER_ID) from dual) REQUESTED_DROP_SHIP_SUPPLIER,

(select msc_get_name.supplier_site(MscBacklogAnalysisEO.SUPPLIER_SITE_ID) from dual) REQUESTED_DSHIP_SUPPLIER_SITE,

CASE

WHEN (MscBacklogAnalysisEO.RESERVATION_STATUS_VALUE =1)

then (select msc_bm_common.GET_RESERVED_SUPPLY_DOC_NUMBER(MscBacklogAnalysisEO.SALES_ORDER_LINE_ID) from dual)

else null

END RESERVED_SUPPLY_DOCUMENT_NUMBER,

CASE

WHEN (MscBacklogAnalysisEO.RESERVATION_STATUS_VALUE =1)

then (select msc_bm_common.GET_RESERVED_SUPPLY_DOC_TYPE(MscBacklogAnalysisEO.SALES_ORDER_LINE_ID) from dual)

else null

END RESERVED_SUPPLY_DOCUMENT_TYPE,

(CASE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =1)

THEN MscBacklogAnalysisEO.EXPECTED_SHIP_DATE

WHEN (MscBacklogAnalysisEO.Order_date_Type_Code =2)

THEN MscBacklogAnalysisEO.EXPECTED_ARRIVAL_DATE

END) PLANNED_DATE,

CASE

When (MscBacklogAnalysisEO.ROW_TYPE=2 and MscBacklogAnalysisEO.NEW_PROMISED_DATE is not null and MscBacklogAnalysisEO.Order_Type_Code!=0)

then DECODE(MscBacklogAnalysisEO.BM_RUN_ID, -1,MscBacklogAnalysisEO.REQUESTED_QUANTITY,MscBacklogAnalysisEO.Using_REQUIREMENT_QUANTITY)

else null

END AVAILABLE_QUANTITY,

CASE

When (MscBacklogAnalysisEO.NEW_PROMISED_DATE is not null)

then MscBacklogAnalysisEO.ITEM

else null

END AVAILABLE_ITEM,

(select msc_get_name.carrier_name(MscBacklogAnalysisEO.CARRIER_ID) from dual) REQUESTED_CARRIER,

(select msc_get_name.msc_sr_lookup_meaning(MscBacklogAnalysisEO.SERVICE_LEVEL,'WSH_SERVICE_LEVELS') from dual) REQUESTED_SERVICE_LEVEL,

(select msc_get_name.msc_sr_lookup_meaning(MscBacklogAnalysisEO.MODE_OF_TRANSPORT,'WSH_MODE_OF_TRANSPORT') from dual) REQUESTED_MODE_OF_TRANSPORT,

(select msc_bm_common.get_ship_method(MscBacklogAnalysisEO.CARRIER_ID,MscBacklogAnalysisEO.MODE_OF_TRANSPORT,MscBacklogAnalysisEO.SERVICE_LEVEL) from dual) REQUESTED_SHIP_METHOD,

(select msc_bm_common.get_ship_method(MscBacklogAnalysisEO.SCHEDULED_CARRIER_ID,MscBacklogAnalysisEO.SCHEDULED_MODE_OF_TRANSPORT_ID,MscBacklogAnalysisEO.SCHEDULED_SERVICE_LEVEL_ID) from dual) SCHEDULED_SHIP_METHOD,

(select msc_bm_common.get_ship_method(MscBacklogAnalysisEO.EXPECTED_CARRIER_ID,MscBacklogAnalysisEO.EXPECTED_MODE_OF_TRANSPORT_ID,MscBacklogAnalysisEO.EXPECTED_SERVICE_LEVEL_ID) from dual) EXPECTED_SHIP_METHOD,

(select msc_get_name.lookup_meaning('ORA_MSC_OP_CTO_ITEM_SUB_TYPE',MscBacklogAnalysisEO.Item_sub_type_code) from dual) ITEM_SUB_TYPE,

(select msc_gopui_util.currency_conversion_rate(MscBacklogAnalysisEO.inventory_item_id,MscBacklogAnalysisEO.organization_id, fnd_global.currency()) from dual) RATE,

(select msc_gopui_util.currency_conversion_rate(MscBacklogAnalysisEO.inventory_item_id,MscBacklogAnalysisEO.organization_id,

fnd_global.currency()) from dual) * MscBacklogAnalysisEO.ORDER_REVENUE

ORDER_REVENUE,

(select msc_gopui_util.currency_conversion_rate(MscBacklogAnalysisEO.inventory_item_id,MscBacklogAnalysisEO.organization_id,

fnd_global.currency()) from dual) * MscBacklogAnalysisEO.ORDER_MARGIN

ORDER_MARGIN,

(select msc_gopui_util.currency_conversion_rate(MscBacklogAnalysisEO.inventory_item_id,MscBacklogAnalysisEO.organization_id, fnd_global.currency()) from dual) * MscBacklogAnalysisEO.SELLING_PRICE

SELLING_PRICE,

(select msc_gopui_util.currency_conversion_rate(MscBacklogAnalysisEO.inventory_item_id,MscBacklogAnalysisEO.organization_id, fnd_global.currency()) from dual) * MscBacklogAnalysisEO.FULFILLMENT_COST

FULFILLMENT_COST,

(select msc_bm_common.lookup_meaning('MSC_OP_WS_ERROR',MscBacklogAnalysisEO.REASON_CODE) from dual) Error_Text,

MscBacklogAnalysisEO.INTERNAL_ORDER_TYPE,

(select msc_get_name.lookup_meaning('ORA_MSC_BM_RULE_SCHEDLE_STATUS',MscBacklogAnalysisEO.SCHEDULING_STATUS_CODE) from dual) SCHEDULING_STATUS,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.RESERVATION_STATUS_VALUE) from dual) RESERVATION_STATUS,

(select msc_get_name.lookup_meaning('ORA_MSC_BM_SET_TYPE',MscBacklogAnalysisEO.Order_date_Type_Code) from dual) REQUEST_TYPE,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.FIRM_SALES_ORDER) from dual) FIRM_SALES_ORDER,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.MANUAL_OVERRIDE_FLAG) from dual) MANUAL_OVERRIDE,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.INQUIRY_DEMAND) from dual) Simulation_Demand,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.ECC_FLAG) from dual) ENFORCE_CURRENT_COMMIT,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.PULL_IN_FLAG) from dual) PULL_IN,

(select msc_get_name.lookup_meaning('ORA_MSC_BM_SET_TYPE',MscBacklogAnalysisEO.SET_TYPE) from dual) SET_TYPE,

(select msc_get_name.lookup_meaning('MSC_YES_NO',MscBacklogAnalysisEO.ALLOW_SPLITS) from dual) ALLOW_SPLITS,

(select msc_bm_common.lookup_meaning('ORA_MSC_BM_ORDER_LINE_STATUS','LOOKUP_CODE-'||MscBacklogAnalysisEO.order_line_status) from dual) order_line_status,

(select msc_bm_common.get_region_name(MscBacklogAnalysisEO.ZONE_ID) from dual) SHIP_TO_ZONE,

(select msc_get_name.org_code(MscBacklogAnalysisEO.RECEIVING_ORG_ID) from dual) SHIP_TO_ORGANIZATION,

(select msc_get_name.org_name(MscBacklogAnalysisEO.RECEIVING_ORG_ID) from dual) SHIP_TO_ORGANIZATION_NAME,

(select msc_bm_common.get_instance_code(MscBacklogAnalysisEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID) from dual) SUPPLIER_SITE_SOURCE_SYSTEM,

(select msc_get_name.ITEM_NAME(TO_NUMBER(MscBacklogAnalysisEO.CONFIGURATION_ITEM),NULL,NULL) from dual) CONFIGURATION_ITEM,

CASE

WHEN (MscBacklogAnalysisEO.INTERNAL_ORDER_TYPE ='TOE' OR MscBacklogAnalysisEO.INTERNAL_ORDER_TYPE ='ISOE' )

then (select msc_bm_common.lookup_meaning('ORA_INV_TO_DESTINATION_TYPE','EXPENSE') from dual)

else (select msc_bm_common.lookup_meaning('ORA_INV_TO_DESTINATION_TYPE','INVENTORY') from dual)

END Destination_Type,

CASE

WHEN (MscBacklogAnalysisEO.SCHEDULING_STATUS_CODE = 1)

THEN MscBacklogAnalysisEO.UOM_CODE

ELSE NULL

END Scheduled_Quantity_UOM,

MscBacklogAnalysisEO.PROMISING_SYSTEM,

(select msc_get_name.lookup_meaning('ORA_MSC_ORDER_RELEASE_STATUS',MscBacklogAnalysisEO.RELEASE_STATUS) from dual) RELEASE_STATUS_MEANING,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER11 IS NOT NULL

then (select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER11',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER11) from dual)

else null

end PLANNING_ATTR_VAL_11,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER12 IS NOT NULL

then (select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER12',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER12) from dual)

else null

end PLANNING_ATTR_VAL_12,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER13 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER13',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER13) from dual)

else null

end PLANNING_ATTR_VAL_13,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER14 IS NOT NULL

then (select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER14',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER14) from dual)

else null

end PLANNING_ATTR_VAL_14,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER15 IS NOT NULL

then (select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER15',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER15) from dual)

else null

end PLANNING_ATTR_VAL_15,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER16 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER16',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER16) from dual)

else null

end PLANNING_ATTR_VAL_16,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER17 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER17',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER17) from dual)

else null

end PLANNING_ATTR_VAL_17,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER18 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER18',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER18) from dual)

else null

end PLANNING_ATTR_VAL_18,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER19 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER19',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER19) from dual)

else null

end PLANNING_ATTR_VAL_19,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER20 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER20',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER20) from dual)

else null

end PLANNING_ATTR_VAL_20,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER21 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER21',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER21) from dual)

else null

end PLANNING_ATTR_VAL_21,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER22 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER22',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER22) from dual)

else null

end PLANNING_ATTR_VAL_22,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER23 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER23',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER23) from dual)

else null

end PLANNING_ATTR_VAL_23,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER24 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER24',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER24) from dual)

else null

end PLANNING_ATTR_VAL_24,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER25 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER25',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER25) from dual)

else null

end PLANNING_ATTR_VAL_25,

Case when MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER26 IS NOT NULL

then(select msc_get_name.get_abp_display_value(-1,'GLOBAL_ATTRIBUTE_NUMBER26',MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_NUMBER26) from dual)

else null

end PLANNING_ATTR_VAL_26,

(select msc_get_name.lookup_meaning('ORA_MSC_BM_SET_TYPE',MscBacklogAnalysisEO.SET_TYPE) from dual) ORIGINAL_SET_TYPE,

Case when (MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR21 IS NOT NULL) OR (MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR22 IS NOT NULL) OR (MscBacklogAnalysisEO.GLOBAL_ATTRIBUTE_CHAR23 IS NOT NULL)

then 1

else 2

end DISPLAY_ATTRIBUTE_CODE

FROM MSC_ORDERS_BM_V MscBacklogAnalysisEO