MSC_ORDERS_SP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

SOURCE_TABLE ROW_ID OBJECT_VERSION_NUMBER TRANSACTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN INVENTORY_ITEM_ID ORGANIZATION_ID ORGANIZATION_CODE PLAN_ORGANIZATION_ID PLAN_INSTANCE_ID PLAN_ID COMPILE_DESIGNATOR NEW_DUE_DATE OLD_DUE_DATE NEW_START_DATE DISPOSITION_ID ORDER_NUMBER DISPOSITION_STATUS_TYPE ORDER_TYPE ORDER_TYPE_TEXT QUANTITY_RATE OLD_ORDER_QUANTITY NEW_ORDER_DATE FIRM_PLANNED_TYPE RESCHEDULED_FLAG IMPLEMENTED_QUANTITY LAST_UNIT_COMPLETION_DATE NEW_DOCK_DATE QUANTITY_IN_PROCESS FIRM_QUANTITY FIRM_DATE LINE_ID IMPLEMENT_DEMAND_CLASS ITEM_SEGMENTS IMPLEMENT_DATE IMPLEMENT_QUANTITY_RATE IMPLEMENT_FIRM IMPLEMENT_PROCESSING_DAYS IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_JOB_NAME IMPLEMENT_LINE_ID IMPLEMENT_STATUS_CODE IMPLEMENT_LOCATION_ID RELEASE_STATUS IMPLEMENT_AS IMPLEMENT_AS_TEXT PLANNER_CODE USING_ASSEMBLY_ITEM_ID MRP_PLANNING_CODE REPETITIVE_TYPE BUILD_IN_WIP_FLAG PURCHASING_ENABLED_FLAG PLANNING_MAKE_BUY_CODE BOM_ITEM_TYPE BASE_ITEM_ID WIP_SUPPLY_TYPE SOURCE_ORGANIZATION_ID SOURCE_SR_INSTANCE_ID SOURCE_ORGANIZATION_CODE STATUS_CODE USING_ASSEMBLY_SEGMENTS SOURCE_VENDOR_NAME SOURCE_VENDOR_SITE_CODE VENDOR_ID SUPPLIER_NAME VENDOR_SITE_ID SUPPLIER_SITE_CODE IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_VENDOR_ID IMPLEMENT_VENDOR_SITE_ID IN_SOURCE_PLAN SCHEDULE_COMPRESSION_DAYS PROJECT_ID TASK_ID IMPLEMENT_PROJECT_ID IMPLEMENT_TASK_ID APPLIED RELEASE_TIME_FENCE_CODE IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_BUILD_SEQUENCE BUILD_SEQUENCE SCHEDULE_GROUP_ID ALTERNATE_BOM_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR PROCESS_SEQ_ID IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_ROUTING SCHEDULE_GROUP_NAME IMPLEMENT_EMPLOYEE_ID BUYER_NAME RELEASE_ERRORS UNIT_NUMBER IMPLEMENT_UNIT_NUMBER DESCRIPTION PRODUCT_FAMILY_ID PRODUCT_FAMILY_NAME BASE_ITEM_NAME UOM_CODE DEMAND_PRIORITY OVERRIDE_DEMAND_PRIORITY PROMISE_DATE REQUEST_DATE CUSTOMER_ID CUSTOMER_NAME CUSTOMER_SITE_ID CUSTOMER_SITE_NAME SHIP_TO_SITE_ID SHIP_TO_SITE_NAME LOT_NUMBER SUBINVENTORY_CODE WIP_STATUS_CODE WIP_STATUS_TEXT DMD_SATISFIED_DATE NEED_BY_DATE DESIGNATOR_NAME SELLING_PRICE DEMAND_CLASS PROBABILITY SHIP_DATE QUANTITY BUCKET_TYPE SOURCE_DMD_PRIORITY RESCHEDULE_DAYS OLD_NEED_BY_DATE ORIGINAL_ITEM_ID ORIGINAL_ITEM_NAME ORIGINAL_ITEM_QTY SHIP_METHOD UNMET_QUANTITY ORIGINAL_QUANTITY ORIGINAL_NEED_BY_DATE EARLIEST_START_DATE LATEST_START_DATE MATERIAL_AVAIL_DATE CONSUMPTION_START_DATE CONTRIBUTES_OVERLOAD CONTRIBUTES_DMD_LATENESS SHARED_SUPPLY USES_ORDER_MODIFIER PEGGED_TO_FIRM RECORD_SOURCE START_QUANTITY EXPIRATION_DATE MRP_PLANNING_CODE_TEXT ORIGINAL_ORG_ID ORIGINAL_INST_ID ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_TEXT SCHEDULE_ARRIVAL_DATE LATEST_ACCEPTABLE_DATE PLANNED_ARRIVAL_DATE SHIPMENT_ID SHIP_CALENDAR RECEIVING_CALENDAR INTRANSIT_CALENDAR INTRANSIT_LEAD_TIME IMPLEMENT_DOCK_DATE IMPLEMENT_SHIP_DATE IMPLEMENT_ARRIVAL_DATE REQUEST_SHIP_DATE PROMISE_SHIP_DATE LATE_DAYS SUBSTITUTE_COMPONENT_RANK SOURCE_TABLE2 SCHEDULE_SHIP_DATE DEST_ORG_CODE QTY_BY_DUE_DATE SHIP_SET_NAME ARRIVAL_SET_NAME DEST_ORG_ID DEST_INST_ID IMPLEMENT_DEST_ORG_ID IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_ORG_CODE ZONE REQUESTED_COMPLETION_DATE LOTS_EXIST IMPLEMENT_SHIP_METHOD ACTUAL_START_DATE IMPLEMENT_DUE_DATE SCHEDULE_DESIGNATOR_ID SALES_ORDER_LINE_ID SHIP_SET_ID ARRIVAL_SET_ID FIRM_START_DATE BILL_SEQUENCE_ID ROUTING_SEQUENCE_ID COMMENTS SUGGESTED_PICK_DATE LOAD_TYPE BASE_PLAN_ID ROUNDING_CONTROL_TYPE OLD_DOCK_DATE PLAN_CUTOFF_DATE PLAN_START_DATE RESERVED_QUANTITY CTB_FLAG CTB_COMP_AVAIL_PERCENT RTB_ORDER_QTY_PERCENT CTB_EXPECTED_DATE CTB_PRIORITY REVISED_DMD_DATE REVISED_DMD_PRIORITY SHIP_METHOD_TEXT ORIG_FIRM_DATE ORIG_FIRM_QUANTITY SO_LINE_NUM ORCH_ORDER_NUMBER ORCH_ORDER_LINE_NUMBER FULFILLMENT_LINE_NUM BMT_FLAG SIMULATION_SET_ID DROP_SHIP_DEST_TYPE RELEASE_ACTION BACK_TO_BACK_FLAG DEMAND_CLASS_CODE NET_SUPPLY_QTY_OVERRIDE IMPLEMENT_BILL_SEQUENCE_ID IMPLEMENT_ROUTING_SEQUENCE_ID CARRIER_ID MODE_OF_TRANSPORT SERVICE_LEVEL IMPLEMENT_CARRIER_ID IMPLEMENT_MODE_OF_TRANSPORT IMPLEMENT_SERVICE_LEVEL IMPLEMENT_SHIP_METHOD_TEXT CUSTOMER_PO_NUMBER ITEM_STRUCTURE_NAME WORK_DEFINITION IMPLEMENT_ITEM_STRUCTURE IMPLEMENT_WORK_DEFINITION DAYS_PAST_DUE QTY_SATISFIED_BY_RDD EXPENSE_TRANSFER PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM QTY_SCRAPPED EXPECTED_SCRAP_QTY QTY_COMPLETED FIRM_START_QUANTITY TIMEZONE_NAME TIMEZONE_CODE SOURCE_TIMEZONE_NAME SOURCE_TIMEZONE_CODE DESTINATION_TIMEZONE_NAME DESTINATION_TIMEZONE_CODE 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_CHAR21 GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR23 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 IS_NON_KEY_CUSTOMER PRIMARY_COMPONENT_ID OPERATION_SEQ_NUM ALT_FACILITY_USED ALT_SUPPLIER_USED ALT_WORK_DEFINITION_USED ALT_RESOURCE_USED SUBSTITUTE_COMPONENT_USED CANCELED TOTAL_OUTPUT_QUANTITY LAST_OP_COMPLETION_DATE WORK_METHOD_CODE PROCESS_NAME BATCH_UOM WORK_ORDER_SUB_TYPE SEGMENT_ID SEGMENT_NAME SUBINV_FLAG SOURCE_SUBINVENTORY_CODE HARD_PEGGING_LEVEL IMPLEMENT_SOURCE_ORG IMPLEMENT_SUPPLIER IMPLEMENT_SUPPLIER_SITE ORG_CURRENCY_CODE QTY_REMAINING PLANNER_DESCRIPTION ISSUED_QUANTITY CONFIGURED_ITEM CONFIGURED_ITEM_NAME ASSET_NUMBER CLUSTER_ID CLUSTER_NAME REPL_INV_REBALANCE_FLAG INIT_EXCESS_AT_SOURCE INIT_SHORTAGE_AT_DEST EXCESS_REDUCTION_AT_SRC SHORTAGE_REDUCTION_AT_DEST ORIGINAL_TRANSACTION_ID HOLD_DATE ORDER_STATUS IMPLEMENT_LOCATION_CODE CHILD_ORGANIZATION_ID CHILD_ORGANIZATION_CODE ORIGINAL_SUBINVENTORY_CODE UNDER_COMPLETED_FLAG SUBST_ITEM_ID SUBST_ITEM_NAME SUBST_ITEM_DESC ORIGINAL_ITEM_DESC ATTRIBUTE_ROW_ID FG_ORDER_TYPE MATURITY_DATE CONSTRAINED_START_DATE

Query

SQL_Statement

SELECT 'MSC_SUPPLIES' AS SOURCE_TABLE, sup.ROWID AS ROW_ID, sup.OBJECT_VERSION_NUMBER, sup.TRANSACTION_ID, sup.LAST_UPDATE_DATE, sup.LAST_UPDATED_BY, sup.CREATION_DATE, sup.CREATED_BY, sup.LAST_UPDATE_LOGIN, sup.INVENTORY_ITEM_ID, sup.ORGANIZATION_ID, msi.ORGANIZATION_CODE, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_number(NULL) AS PLAN_INSTANCE_ID, sup.PLAN_ID, MSC_SPUI_COMMON.plan_name(sup.PLAN_ID) as COMPILE_DESIGNATOR, sup.NEW_SCHEDULE_DATE AS NEW_DUE_DATE, sup.OLD_SCHEDULE_DATE AS OLD_DUE_DATE, sup.NEW_WIP_START_DATE AS NEW_START_DATE, sup.DISPOSITION_ID, msc_get_name.supply_order_number_new ( sup.order_type ,sup.order_number ,sup.transaction_id ,sup.disposition_id,sup.fg_order_type ) AS ORDER_NUMBER, sup.DISPOSITION_STATUS_TYPE, sup.ORDER_TYPE, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) AS ORDER_TYPE_TEXT, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) AS QUANTITY_RATE, sup.OLD_ORDER_QUANTITY, NVL(sup.NEW_ORDER_PLACEMENT_DATE , sup.firm_date) AS NEW_ORDER_DATE, sup.FIRM_PLANNED_TYPE, sup.RESCHEDULE_FLAG AS RESCHEDULED_FLAG, sup.IMPLEMENTED_QUANTITY, sup.LAST_UNIT_COMPLETION_DATE, sup.NEW_DOCK_DATE, sup.QUANTITY_IN_PROCESS, sup.FIRM_QUANTITY, sup.FIRM_DATE, sup.LINE_ID, sup.IMPLEMENT_DEMAND_CLASS, msi.item_name AS ITEM_SEGMENTS, sup.IMPLEMENT_DATE, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) AS IMPLEMENT_QUANTITY_RATE , sup.IMPLEMENT_FIRM, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, sup.IMPLEMENT_WIP_CLASS_CODE, sup.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, sup.IMPLEMENT_STATUS_CODE, sup.IMPLEMENT_LOCATION_ID, NVL(sup.RELEASE_STATUS,-1) AS RELEASE_STATUS, sup.IMPLEMENT_AS, DECODE(sup.implement_as, NULL, NULL, msc_get_name.lookup_meaning( 'ORA_MSC_WORKBENCH_IMPLEMENT_AS',sup.implement_as)) AS IMPLEMENT_AS_TEXT, msi.PLANNER_CODE, to_number(NULL) AS USING_ASSEMBLY_ITEM_ID, msi.MRP_PLANNING_CODE, NULL AS REPETITIVE_TYPE, msi.BUILD_IN_WIP_FLAG, msi.PURCHASING_ENABLED_FLAG, msi.PLANNING_MAKE_BUY_CODE, msi.BOM_ITEM_TYPE, msi.BASE_ITEM_ID, msi.WIP_SUPPLY_TYPE, sup.SOURCE_ORGANIZATION_ID, NULL AS SOURCE_SR_INSTANCE_ID, msc_get_name.org_code(sup.source_organization_id) AS SOURCE_ORGANIZATION_CODE, sup.wip_status_code AS STATUS_CODE, NULL AS USING_ASSEMBLY_SEGMENTS, msc_get_name.supplier(sup.supplier_id) AS SOURCE_VENDOR_NAME, msc_get_name.supplier_site(sup.supplier_site_id) AS SOURCE_VENDOR_SITE_CODE, sup.supplier_id AS VENDOR_ID, NULL AS SUPPLIER_NAME, sup.supplier_site_id AS VENDOR_SITE_ID, NULL AS SUPPLIER_SITE_CODE, sup.IMPLEMENT_SOURCE_ORG_ID, NULL AS IMPLEMENT_SR_INSTANCE_ID, sup.implement_supplier_id AS IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id AS IMPLEMENT_VENDOR_SITE_ID, DECODE(NULL, 1, 1,2) AS IN_SOURCE_PLAN, sup.schedule_compress_days AS SCHEDULE_COMPRESSION_DAYS, sup.PROJECT_ID, sup.TASK_ID, sup.IMPLEMENT_PROJECT_ID, sup.IMPLEMENT_TASK_ID, sup.APPLIED, msi.RELEASE_TIME_FENCE_CODE, sup.IMPLEMENT_SCHEDULE_GROUP_ID, sup.IMPLEMENT_BUILD_SEQUENCE, DECODE(sup.ORDER_TYPE, 3, sup.BUILD_SEQUENCE, 7, sup.BUILD_SEQUENCE, 14, sup.BUILD_SEQUENCE, 15, sup.BUILD_SEQUENCE, 27, sup.BUILD_SEQUENCE, to_number( NULL)) AS BUILD_SEQUENCE, DECODE(sup.ORDER_TYPE, 3, sup.SCHEDULE_GROUP_ID, 7, sup.SCHEDULE_GROUP_ID, 14, sup.SCHEDULE_GROUP_ID, 15, sup.SCHEDULE_GROUP_ID, 27, sup.SCHEDULE_GROUP_ID, to_number(NULL)) AS SCHEDULE_GROUP_ID, sup.ALTERNATE_BOM_DESIGNATOR, sup.ALTERNATE_ROUTING_DESIGNATOR, sup.PROCESS_SEQ_ID, sup.IMPLEMENT_ALTERNATE_BOM, sup.IMPLEMENT_ALTERNATE_ROUTING, sup.SCHEDULE_GROUP_NAME, sup.IMPLEMENT_EMPLOYEE_ID, msi.BUYER_NAME AS BUYER_NAME, sup.RELEASE_ERRORS, sup.UNIT_NUMBER, sup.IMPLEMENT_UNIT_NUMBER, msi.DESCRIPTION, msi.PRODUCT_FAMILY_ID, msc_get_name.item_name(msi.product_family_id,NULL,NULL) AS PRODUCT_FAMILY_NAME, NULL AS base_item_name, msi.UOM_CODE, sup.schedule_priority AS DEMAND_PRIORITY, NULL AS OVERRIDE_DEMAND_PRIORITY, sup.promised_date AS PROMISE_DATE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) AS REQUEST_DATE, nvl(sup.drop_ship_cust_id, sup.customer_id) AS CUSTOMER_ID, msc_get_name.customer(nvl(sup.drop_ship_cust_id, sup.customer_id)) AS CUSTOMER_NAME, nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID) AS CUSTOMER_SITE_ID, msc_get_name.customer_site( nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID)) AS CUSTOMER_SITE_NAME, to_number(NULL) AS SHIP_TO_SITE_ID, NULL AS SHIP_TO_SITE_NAME, sup.LOT_NUMBER, sup.SUBINVENTORY_CODE, sup.WIP_STATUS_CODE, msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) AS WIP_STATUS_TEXT, to_date(NULL) AS DMD_SATISFIED_DATE, sup.NEED_BY_DATE, NVL(sup.schedule_designator, msc_get_name.designator(sup.schedule_designator_id, null, sup.plan_id)) AS DESIGNATOR_NAME, to_number(NULL) AS SELLING_PRICE, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) AS DEMAND_CLASS, to_number(NULL) AS PROBABILITY, sup.new_ship_date AS SHIP_DATE, sup.new_order_quantity AS QUANTITY , NULL AS BUCKET_TYPE, to_number(NULL) AS SOURCE_DMD_PRIORITY, sup.RESCHEDULE_DAYS, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) AS OLD_NEED_BY_DATE , sup.ORIGINAL_ITEM_ID, msc_get_name.item_name(sup.original_item_id, NULL, NULL) AS ORIGINAL_ITEM_NAME, to_number(NULL) AS ORIGINAL_ITEM_QTY, sup.SHIP_METHOD, to_number(NULL) AS UNMET_QUANTITY, sup.ORIGINAL_QUANTITY, sup.ORIGINAL_NEED_BY_DATE, sup.earliest_start_date, sup.Latest_Start_Date, sup.Material_Avail_Date, sup.Consumption_Start_Date, sup.Contributes_Overload, sup.Contributes_dmd_lateness, sup.Shared_Supply, sup.Uses_Order_Modifier, sup.Pegged_to_Firm, sup.RECORD_SOURCE, sup.START_QUANTITY, sup.EXPIRATION_DATE, msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE',msi.mrp_planning_code) AS MRP_PLANNING_CODE_TEXT, to_number(NULL) AS ORIGINAL_ORG_ID, to_number(NULL) AS ORIGINAL_INST_ID, to_number(NULL) AS ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) AS ORDER_DATE_TYPE_TEXT, to_date(NULL) AS SCHEDULE_ARRIVAL_DATE, to_date(NULL) AS LATEST_ACCEPTABLE_DATE, to_date(NULL) AS PLANNED_ARRIVAL_DATE, sup.SHIPMENT_ID, sup.SHIP_CALENDAR, sup.RECEIVING_CALENDAR, sup.INTRANSIT_CALENDAR, sup.INTRANSIT_LEAD_TIME, sup.IMPLEMENT_DOCK_DATE, sup.IMPLEMENT_SHIP_DATE, to_date(NULL) AS IMPLEMENT_ARRIVAL_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) AS REQUEST_SHIP_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) AS PROMISE_SHIP_DATE, sup.days_late AS LATE_DAYS, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, 'MSC_SUPPLIES' AS SOURCE_TABLE2, to_date(NULL) AS SCHEDULE_SHIP_DATE, NULL AS DEST_ORG_CODE, to_number(NULL) AS QTY_BY_DUE_DATE, NULL AS SHIP_SET_NAME, NULL AS ARRIVAL_SET_NAME, to_number(NULL) AS DEST_ORG_ID, to_number(NULL) AS DEST_INST_ID, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, msc_get_name.get_zone_name(sup.zone_id) ZONE, sup.REQUESTED_COMPLETION_DATE, NULL AS LOTS_EXIST, sup.IMPLEMENT_SHIP_METHOD, sup.ACTUAL_START_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, sup.schedule_designator_id AS SCHEDULE_DESIGNATOR_ID, NULL AS sales_order_line_id , to_number(NULL) AS ship_set_id, to_number(NULL) AS arrival_set_id, sup.FIRM_START_DATE, sup.BILL_SEQUENCE_ID, sup.ROUTING_SEQUENCE_ID, msc_get_name.get_order_Comments(sup.plan_id, 'SUPPLY', sup.TRANSACTION_ID) AS COMMENTS, to_date(NULL) AS SUGGESTED_PICK_DATE, sup.LOAD_TYPE, msi.plan_id AS base_plan_id, msi.ROUNDING_CONTROL_TYPE, sup.OLD_DOCK_DATE, NULL AS plan_cutoff_date, NULL AS plan_start_date, decode(msi.plan_id, -1, nvl(msc_get_name.get_supply_reserved_quantity(sup.order_type, sup.organization_id, sup.po_line_location_id, sup.wip_entity_name, sup.to_line_id, sup.subinventory_code, sup.reserved_quantity), sup.reserved_quantity), sup.reserved_quantity) AS reserved_quantity, sup.CTB_FLAG, sup.CTB_COMP_AVAIL_PERCENT, sup.RTB_ORDER_QTY_PERCENT, sup.CTB_EXPECTED_DATE, sup.CTB_PRIOIRTY AS CTB_PRIORITY, to_date(NULL) AS revised_dmd_date , to_number(NULL) AS revised_dmd_priority , nvl(sup.ship_method, msc_get_name.get_ship_method(sup.carrier_id, sup.mode_of_transport, sup.service_level)) AS ship_method_text, sup.ORIG_FIRM_DATE, sup.ORIG_FIRM_QUANTITY, to_char(null) as SO_LINE_NUM, to_char(null) AS ORCH_ORDER_NUMBER, msc_get_name.supply_order_line_number(sup.order_type, sup.fg_order_type, sup.purch_line_num, sup.to_line_number) AS ORCH_ORDER_LINE_NUMBER, to_number(null) AS FULFILLMENT_LINE_NUM, sup.BMT_FLAG, msi.SIMULATION_SET_ID, sup.DROP_SHIP_DEST_TYPE, MSC_SPUI_COMMON.release_action ('MSC_SUPPLIES',sup.plan_id,sup.ORGANIZATION_ID,msi.INVENTORY_ITEM_ID,sup.order_type,sup.TRANSACTION_ID,msi.PURCHASING_ENABLED_FLAG,nvl(sup.reschedule_flag,2),nvl(sup.reschedule_days,0),msi.release_time_fence_code,msi.BUILD_IN_WIP_FLAG,sup.SOURCE_ORGANIZATION_ID,sup.new_order_quantity,sup.FIRM_QUANTITY,sup.RELEASE_STATUS,msi.wip_supply_type,msi.BOM_ITEM_TYPE,msi.PLANNING_MAKE_BUY_CODE,sup.implemented_quantity,sup.original_quantity,sup.DISPOSITION_STATUS_TYPE,sup.reserved_quantity,sup.routing_sequence_id,msi.PLANNER_CODE,sup.FIRM_PLANNED_TYPE,sup.applied,sup.drop_ship_dest_type,msi.back_to_back_flag,msi.in_source_plan,sup.release_errors,sup.fg_order_type) as release_action, msi.back_to_back_flag, msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, sup.NET_SUPPLY_QTY_OVERRIDE, sup.IMPLEMENT_BILL_SEQUENCE_ID, sup.IMPLEMENT_ROUTING_SEQUENCE_ID, sup.CARRIER_ID, sup.MODE_OF_TRANSPORT, sup.SERVICE_LEVEL, sup.IMPLEMENT_CARRIER_ID, sup.implement_mode_of_transport_id AS IMPLEMENT_MODE_OF_TRANSPORT, sup.implement_service_level_id AS IMPLEMENT_SERVICE_LEVEL, nvl(sup.implement_ship_method, msc_get_name.get_ship_method(sup.implement_carrier_id, sup.implement_mode_of_transport_id, sup.implement_service_level_id)) AS IMPLEMENT_SHIP_METHOD_TEXT, to_char(null) AS CUSTOMER_PO_NUMBER, msc_get_name.get_item_structure_name(msi.plan_id,sup.bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) AS ITEM_STRUCTURE_NAME, CASE WHEN (sup.routing_sequence_id IS NULL AND sup.bill_sequence_id IS NOT NULL ) THEN 'NotAvailable' ELSE msc_get_name.get_work_definition(msi.plan_id, sup.routing_sequence_id, sup.organization_id, msi.SIMULATION_SET_ID) END AS WORK_DEFINITION, msc_get_name.get_item_structure_name(msi.plan_id, sup.implement_bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) AS IMPLEMENT_ITEM_STRUCTURE, msc_get_name.get_work_definition(msi.plan_id, sup.implement_routing_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) AS IMPLEMENT_WORK_DEFINITION, sup.DAYS_PAST_DUE, to_number(null) AS QTY_SATISFIED_BY_RDD, 2 AS EXPENSE_TRANSFER, to_number(null) AS PARENT_MODEL_ITEM_ID, to_char(null) AS PARENT_MODEL_ITEM, sup.qty_scrapped AS QTY_SCRAPPED,sup.expected_scrap_qty AS EXPECTED_SCRAP_QTY, sup.qty_completed AS QTY_COMPLETED, sup.firm_start_quantity AS FIRM_START_QUANTITY, msc_get_name.get_timezone_name(sup.organization_id) AS TIMEZONE_NAME, msc_get_name.get_timezone_code(sup.organization_id) AS TIMEZONE_CODE, msc_get_name.get_source_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) AS SOURCE_TIMEZONE_NAME, msc_get_name.get_source_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) AS SOURCE_TIMEZONE_CODE, msc_get_name.get_destination_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) AS DESTINATION_TIMEZONE_NAME, msc_get_name.get_destination_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) AS DESTINATION_TIMEZONE_CODE, sup.ATTRIBUTE_CATEGORY, sup.ATTRIBUTE_CHAR1, sup.ATTRIBUTE_CHAR2, sup.ATTRIBUTE_CHAR3, sup.ATTRIBUTE_CHAR4, sup.ATTRIBUTE_CHAR5, sup.ATTRIBUTE_CHAR6, sup.ATTRIBUTE_CHAR7, sup.ATTRIBUTE_CHAR8, sup.ATTRIBUTE_CHAR9, sup.ATTRIBUTE_CHAR10, sup.ATTRIBUTE_CHAR11, sup.ATTRIBUTE_CHAR12, sup.ATTRIBUTE_CHAR13, sup.ATTRIBUTE_CHAR14, sup.ATTRIBUTE_CHAR15, sup.ATTRIBUTE_CHAR16, sup.ATTRIBUTE_CHAR17, sup.ATTRIBUTE_CHAR18, sup.ATTRIBUTE_CHAR19, sup.ATTRIBUTE_CHAR20, sup.ATTRIBUTE_NUMBER1, sup.ATTRIBUTE_NUMBER2, sup.ATTRIBUTE_NUMBER3, sup.ATTRIBUTE_NUMBER4, sup.ATTRIBUTE_NUMBER5, sup.ATTRIBUTE_NUMBER6, sup.ATTRIBUTE_NUMBER7, sup.ATTRIBUTE_NUMBER8, sup.ATTRIBUTE_NUMBER9, sup.ATTRIBUTE_NUMBER10, sup.ATTRIBUTE_DATE1, sup.ATTRIBUTE_DATE2, sup.ATTRIBUTE_DATE3, sup.ATTRIBUTE_DATE4, sup.ATTRIBUTE_DATE5, sup.ATTRIBUTE_DATE6, sup.ATTRIBUTE_DATE7, sup.ATTRIBUTE_DATE8, sup.ATTRIBUTE_DATE9, sup.ATTRIBUTE_DATE10, sup.ATTRIBUTE_DATE11, sup.ATTRIBUTE_DATE12, sup.ATTRIBUTE_DATE13, sup.ATTRIBUTE_DATE14, sup.ATTRIBUTE_DATE15, sup.ATTRIBUTE_DATE16, sup.ATTRIBUTE_DATE17, sup.ATTRIBUTE_DATE18, sup.ATTRIBUTE_DATE19, sup.ATTRIBUTE_DATE20, sup.GLOBAL_ATTRIBUTE_CHAR1, sup.GLOBAL_ATTRIBUTE_CHAR2, sup.GLOBAL_ATTRIBUTE_CHAR3, sup.GLOBAL_ATTRIBUTE_CHAR4, sup.GLOBAL_ATTRIBUTE_CHAR5, sup.GLOBAL_ATTRIBUTE_CHAR6, sup.GLOBAL_ATTRIBUTE_CHAR7, sup.GLOBAL_ATTRIBUTE_CHAR8, sup.GLOBAL_ATTRIBUTE_CHAR9, sup.GLOBAL_ATTRIBUTE_CHAR10, sup.GLOBAL_ATTRIBUTE_CHAR11, sup.GLOBAL_ATTRIBUTE_CHAR12, sup.GLOBAL_ATTRIBUTE_CHAR13, sup.GLOBAL_ATTRIBUTE_CHAR14, sup.GLOBAL_ATTRIBUTE_CHAR15, sup.GLOBAL_ATTRIBUTE_CHAR16, sup.GLOBAL_ATTRIBUTE_CHAR17, sup.GLOBAL_ATTRIBUTE_CHAR18, sup.GLOBAL_ATTRIBUTE_CHAR19, sup.GLOBAL_ATTRIBUTE_CHAR20, sup.GLOBAL_ATTRIBUTE_CHAR21, sup.GLOBAL_ATTRIBUTE_CHAR22, sup.GLOBAL_ATTRIBUTE_CHAR23, sup.GLOBAL_ATTRIBUTE_NUMBER1, sup.GLOBAL_ATTRIBUTE_NUMBER2, sup.GLOBAL_ATTRIBUTE_NUMBER3, sup.GLOBAL_ATTRIBUTE_NUMBER4, sup.GLOBAL_ATTRIBUTE_NUMBER5, sup.GLOBAL_ATTRIBUTE_NUMBER6, sup.GLOBAL_ATTRIBUTE_NUMBER7, sup.GLOBAL_ATTRIBUTE_NUMBER8, sup.GLOBAL_ATTRIBUTE_NUMBER9, sup.GLOBAL_ATTRIBUTE_NUMBER10, sup.GLOBAL_ATTRIBUTE_NUMBER11, sup.GLOBAL_ATTRIBUTE_NUMBER12, sup.GLOBAL_ATTRIBUTE_NUMBER13, sup.GLOBAL_ATTRIBUTE_NUMBER14, sup.GLOBAL_ATTRIBUTE_NUMBER15, sup.GLOBAL_ATTRIBUTE_NUMBER16, sup.GLOBAL_ATTRIBUTE_NUMBER17, sup.GLOBAL_ATTRIBUTE_NUMBER18, sup.GLOBAL_ATTRIBUTE_NUMBER19, sup.GLOBAL_ATTRIBUTE_NUMBER20, sup.GLOBAL_ATTRIBUTE_NUMBER21, sup.GLOBAL_ATTRIBUTE_NUMBER22, sup.GLOBAL_ATTRIBUTE_NUMBER23, sup.GLOBAL_ATTRIBUTE_NUMBER24, sup.GLOBAL_ATTRIBUTE_NUMBER25, sup.GLOBAL_ATTRIBUTE_NUMBER26, sup.GLOBAL_ATTRIBUTE_NUMBER27, sup.GLOBAL_ATTRIBUTE_NUMBER28, sup.GLOBAL_ATTRIBUTE_NUMBER29, sup.GLOBAL_ATTRIBUTE_NUMBER30, sup.GLOBAL_ATTRIBUTE_NUMBER31, sup.GLOBAL_ATTRIBUTE_NUMBER32, sup.GLOBAL_ATTRIBUTE_NUMBER33, sup.GLOBAL_ATTRIBUTE_NUMBER34, sup.GLOBAL_ATTRIBUTE_NUMBER35, sup.GLOBAL_ATTRIBUTE_NUMBER36, sup.GLOBAL_ATTRIBUTE_NUMBER37, sup.GLOBAL_ATTRIBUTE_NUMBER38, sup.GLOBAL_ATTRIBUTE_NUMBER39, sup.GLOBAL_ATTRIBUTE_NUMBER40, sup.GLOBAL_ATTRIBUTE_DATE1, sup.GLOBAL_ATTRIBUTE_DATE2, sup.GLOBAL_ATTRIBUTE_DATE3, sup.GLOBAL_ATTRIBUTE_DATE4, sup.GLOBAL_ATTRIBUTE_DATE5, sup.GLOBAL_ATTRIBUTE_DATE6, sup.GLOBAL_ATTRIBUTE_DATE7, sup.GLOBAL_ATTRIBUTE_DATE8, sup.GLOBAL_ATTRIBUTE_DATE9, sup.GLOBAL_ATTRIBUTE_DATE10, sup.GLOBAL_ATTRIBUTE_DATE11, sup.GLOBAL_ATTRIBUTE_DATE12, sup.GLOBAL_ATTRIBUTE_DATE13, sup.GLOBAL_ATTRIBUTE_DATE14, sup.GLOBAL_ATTRIBUTE_DATE15, sup.GLOBAL_ATTRIBUTE_DATE16, sup.GLOBAL_ATTRIBUTE_DATE17, sup.GLOBAL_ATTRIBUTE_DATE18, sup.GLOBAL_ATTRIBUTE_DATE19, sup.GLOBAL_ATTRIBUTE_DATE20, 2 AS IS_NON_KEY_CUSTOMER, NULL AS PRIMARY_COMPONENT_ID, sup.operation_seq_num, sup.alt_facility_used AS ALT_FACILITY_USED, sup.alt_supplier_used AS ALT_SUPPLIER_USED, sup.alt_work_definition_used AS ALT_WORK_DEFINITION_USED, sup.alt_resource_used AS ALT_RESOURCE_USED, sup.substitute_component_used AS SUBSTITUTE_COMPONENT_USED, decode(sup.disposition_status_type, 1,2,2,1,null) AS CANCELED, sup.total_output_quantity, sup.last_op_completion_date, nvl(sup.work_method_code,1) AS WORK_METHOD_CODE, sup.process_name, msc_get_name.get_unit_of_measure(sup.uom_code) as BATCH_UOM, sup.work_order_sub_type, msi.segment_id, msc_get_name.segment_name(msi.segment_id) as SEGMENT_NAME, sup.subinv_flag, sup.source_subinventory_code, msi.hard_pegging_level, msc_get_name.org_code(sup.IMPLEMENT_SOURCE_ORG_ID) as implement_source_org, msc_get_name.supplier(sup.IMPLEMENT_SUPPLIER_ID) as implement_supplier, msc_get_name.supplier_site(sup.IMPLEMENT_SUPPLIER_SITE_ID) as implement_supplier_site, to_char(null) AS ORG_CURRENCY_CODE, nvl(sup.start_quantity,0)-nvl(sup.qty_completed,0)-nvl(sup.qty_scrapped,0) as QTY_REMAINING, msc_get_name.get_planner_desc(msi.PLANNER_CODE) AS PLANNER_DESCRIPTION, sup.quantity_issued AS ISSUED_QUANTITY, to_number(null) AS CONFIGURED_ITEM, to_char(null) AS CONFIGURED_ITEM_NAME, sup.asset_number AS ASSET_NUMBER, sup.cluster_id AS CLUSTER_ID, msc_get_name.cluster_name(sup.cluster_id) AS CLUSTER_NAME, sup.REPL_INV_REBALANCE_FLAG AS REPL_INV_REBALANCE_FLAG, sup.INIT_EXCESS_AT_SOURCE AS INIT_EXCESS_AT_SOURCE, sup.INIT_SHORTAGE_AT_DEST AS INIT_SHORTAGE_AT_DEST, decode(nvl(sup.INIT_EXCESS_AT_SOURCE ,0), 0, to_number(null), (sup.new_order_quantity /sup.INIT_EXCESS_AT_SOURCE) * 100) AS EXCESS_REDUCTION_AT_SRC, decode(nvl(sup.INIT_SHORTAGE_AT_DEST ,0),0,to_number(null), (sup.new_order_quantity /sup.INIT_SHORTAGE_AT_DEST) * 100) AS SHORTAGE_REDUCTION_AT_DEST, to_number(null) as original_transaction_id, sup.hold_date AS HOLD_DATE, case when sup.order_type in (3) then sup.wip_status_code * 10000 when sup.order_type in (1,3,94) then sup.order_status else null end as order_status, msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) as implement_location_code, sup.child_organization_id, msc_get_name.org_code(sup.child_organization_id) as child_organization_code, sup.original_subinventory_code, sup.UNDER_COMPLETED_FLAG, sup.SUBST_ITEM_ID, msc_get_name.item_name(sup.subst_item_id, NULL, NULL) AS SUBST_ITEM_NAME, msc_get_name.item_desc(sup.subst_item_id, sup.ORGANIZATION_ID, sup.PLAN_ID) AS SUBST_ITEM_DESC, msc_get_name.item_desc(sup.original_item_id, sup.ORGANIZATION_ID, sup.PLAN_ID) as ORIGINAL_ITEM_DESC, sup.ATTRIBUTE_ROW_ID, sup.fg_order_type, sup.maturity_date, sup.constrained_start_date FROM MSC_SUPPLIES SUP, msc_system_items msi WHERE msi.plan_id =NVL(sup.base_plan_id, sup.plan_id) AND msi.new_plan_id = -1 AND msi.simulation_set_id =-1 AND sup.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND sup.ORGANIZATION_ID = msi.ORGANIZATION_ID UNION ALL SELECT 'MSC_DEMANDS' AS SOURCE_TABLE, dem.ROWID AS ROW_ID, dem.OBJECT_VERSION_NUMBER, dem.DEMAND_ID AS TRANSACTION_ID, dem.LAST_UPDATE_DATE, dem.LAST_UPDATED_BY, dem.CREATION_DATE, dem.CREATED_BY, dem.LAST_UPDATE_LOGIN, dem.INVENTORY_ITEM_ID, dem.ORGANIZATION_ID, msi.ORGANIZATION_CODE, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_number(NULL) AS PLAN_INSTANCE_ID, dem.PLAN_ID, MSC_SPUI_COMMON.plan_name(dem.PLAN_ID) as COMPILE_DESIGNATOR, dem.USING_ASSEMBLY_DEMAND_DATE AS NEW_DUE_DATE, dem.OLD_DEMAND_DATE AS OLD_DUE_DATE, TO_DATE(NULL) AS NEW_START_DATE, dem.DISPOSITION_ID, msc_get_name.demand_order_number_new(dem.origination_type,dem.order_number,dem.plan_id,dem.disposition_id,dem.wip_entity_name, dem.orch_order_number,dem.schedule_designator_id,dem.SALES_ORDER_NUMBER,dem.demand_id) as ORDER_NUMBER, TO_NUMBER(NULL) DISPOSITION_STATUS_TYPE, dem.origination_type ORDER_TYPE, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) AS ORDER_TYPE_TEXT, -NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) AS QUANTITY_RATE, dem.OLD_DEMAND_QUANTITY AS OLD_ORDER_QUANTITY, TO_DATE(NULL) AS NEW_ORDER_DATE, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) AS FIRM_PLANNED_TYPE, dem.reschedule_flag AS RESCHEDULED_FLAG, TO_NUMBER(NULL) AS IMPLEMENTED_QUANTITY, TO_DATE(NULL) AS LAST_UNIT_COMPLETION_DATE, TO_DATE(NULL) AS NEW_DOCK_DATE, TO_NUMBER(NULL) AS QUANTITY_IN_PROCESS, dem.FIRM_QUANTITY, dem.FIRM_DATE, TO_NUMBER(NULL) AS LINE_ID, NULL AS IMPLEMENT_DEMAND_CLASS, msi.item_name AS ITEM_SEGMENTS, dem.IMPLEMENT_DATE, TO_NUMBER(NULL) AS IMPLEMENT_QUANTITY_RATE, dem.IMPLEMENT_FIRM, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, TO_CHAR(NULL) AS IMPLEMENT_WIP_CLASS_CODE, NULL AS IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, TO_NUMBER(NULL) AS IMPLEMENT_STATUS_CODE, TO_NUMBER(NULL) AS IMPLEMENT_LOCATION_ID, NVL(dem.RELEASE_STATUS,-1) AS RELEASE_STATUS, TO_NUMBER(NULL) AS IMPLEMENT_AS, NULL AS IMPLEMENT_AS_TEXT, msi.PLANNER_CODE, dem.USING_ASSEMBLY_ITEM_ID, msi.MRP_PLANNING_CODE, NULL AS REPETITIVE_TYPE, msi.BUILD_IN_WIP_FLAG, msi.PURCHASING_ENABLED_FLAG, msi.PLANNING_MAKE_BUY_CODE, msi.BOM_ITEM_TYPE, msi.BASE_ITEM_ID, msi.WIP_SUPPLY_TYPE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id AS SOURCE_SR_INSTANCE_ID, DECODE(dem.supply_id, NULL, DECODE(dem.origination_type, 1006, DECODE( msc_get_name.order_type(dem.plan_id, dem.disposition_id ), 2, NULL, msc_get_name.org_code(dem.source_organization_id)), 1030, DECODE(msc_get_name.order_type( dem.plan_id, dem.disposition_id), 2, NULL, msc_get_name.org_code(dem.source_organization_id)), msc_get_name.org_code( dem.source_organization_id)), NULL ) AS SOURCE_ORGANIZATION_CODE, TO_NUMBER(NULL) AS STATUS_CODE, msc_get_name.item_name(dem.using_assembly_item_id, NULL, NULL) AS USING_ASSEMBLY_SEGMENTS, msc_get_name.supplier(dem.supplier_id) AS SOURCE_VENDOR_NAME, msc_get_name.supplier_site(dem.supplier_site_id) AS SOURCE_VENDOR_SITE_CODE, dem.supplier_id AS VENDOR_ID, NULL AS SUPPLIER_NAME, dem.supplier_site_id AS VENDOR_SITE_ID, NULL AS SUPPLIER_SITE_CODE, dem.implement_org_id AS IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id AS IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_SITE_ID, DECODE(NULL, 1, 1, 2) AS IN_SOURCE_PLAN, to_number(NULL) AS SCHEDULE_COMPRESSION_DAYS, dem.PROJECT_ID, dem.TASK_ID, to_number(NULL) AS IMPLEMENT_PROJECT_ID, to_number(NULL) AS IMPLEMENT_TASK_ID, dem.APPLIED, to_number(NULL) AS RELEASE_TIME_FENCE_CODE, to_number(NULL) AS IMPLEMENT_SCHEDULE_GROUP_ID, to_number(NULL) AS IMPLEMENT_BUILD_SEQUENCE, to_number(NULL) AS BUILD_SEQUENCE, to_number(NULL) AS SCHEDULE_GROUP_ID, NULL AS ALTERNATE_BOM_DESIGNATOR, NULL AS ALTERNATE_ROUTING_DESIGNATOR, to_number(NULL) AS PROCESS_SEQ_ID, NULL AS IMPLEMENT_ALTERNATE_BOM, NULL AS IMPLEMENT_ALTERNATE_ROUTING, NULL AS SCHEDULE_GROUP_NAME, to_number(NULL) AS IMPLEMENT_EMPLOYEE_ID, msi.BUYER_NAME AS BUYER_NAME, dem.RELEASE_ERRORS, dem.UNIT_NUMBER, NULL AS IMPLEMENT_UNIT_NUMBER, msi.DESCRIPTION, msi.PRODUCT_FAMILY_ID, msc_get_name.item_name(msi.product_family_id, NULL, NULL) AS PRODUCT_FAMILY_NAME, NULL AS base_item_name, msi.UOM_CODE, DECODE(dem.plan_id,-1, dem.order_priority, dem.demand_priority) DEMAND_PRIORITY, dem.OVERRIDE_DEMAND_PRIORITY, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) AS PROMISE_DATE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) AS REQUEST_DATE, dem.CUSTOMER_ID, msc_get_name.customer(dem.customer_id) CUSTOMER_NAME, dem.CUSTOMER_SITE_ID, msc_get_name.customer_site( dem.customer_site_id) CUSTOMER_SITE_NAME, dem.SHIP_TO_SITE_ID, msc_get_name.customer_site(dem.ship_to_site_id) AS SHIP_TO_SITE_NAME, dem.LOT_NUMBER, dem.sub_inventory_code AS SUBINVENTORY_CODE, to_number(NULL) AS WIP_STATUS_CODE, NULL AS WIP_STATUS_TEXT, dem.DMD_SATISFIED_DATE, to_date(NULL) AS NEED_BY_DATE, msc_get_name.designator(dem.schedule_designator_id, null, dem.plan_id) as DESIGNATOR_NAME, decode(dem.origination_type, 1029, nvl(dem.selling_price, msi.list_price * (1- nvl(msi.average_discount, 0)/100)), 1030, nvl(dem.selling_price, msi.list_price* (1- nvl(msi.average_discount, 0)/100)), 1008, nvl(dem.selling_price, msi.list_price* (1- nvl(msi.average_discount, 0)/100)), dem.selling_price) AS SELLING_PRICE, dem.DEMAND_CLASS, dem.PROBABILITY, dem.planned_ship_date AS SHIP_DATE, -dem.using_requirement_quantity AS QUANTITY, DECODE(dem.origination_type, 1001, NULL, 1004, NULL, 1016, NULL, 1017, NULL, 1018, NULL , 1019, NULL, 1020, NULL, 1021, NULL, 1023, NULL, 1025, NULL, 1026, NULL, 1028, NULL, 1022, NULL, decode(msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG',dem.bucket_type), null,msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_GREGORIAN',dem.bucket_type),msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG', dem.bucket_type))) AS BUCKET_TYPE, to_number(null) AS SOURCE_DMD_PRIORITY, to_number(NULL) AS RESCHEDULE_DAYS, to_date(NULL) AS OLD_NEED_BY_DATE, dem.ORIGINAL_ITEM_ID, msc_get_name.item_name(dem.original_item_id, NULL, NULL) AS ORIGINAL_ITEM_NAME, dem.original_quantity AS ORIGINAL_ITEM_QTY, dem.SHIP_METHOD, dem.UNMET_QUANTITY, DECODE(dem.origination_type, 1029, to_number(NULL), 1008, to_number(NULL), dem.using_requirement_quantity+nvl(dem.completed_quantity,0)) AS ORIGINAL_QUANTITY, to_date(NULL) AS ORIGINAL_NEED_BY_DATE, to_date(NULL) as Earliest_start_date, to_date(NULL) as Latest_Start_Date, to_date(NULL) as Material_Avail_Date, to_date(NULL) as Consumption_Start_Date, NULL as Contributes_Overload, NULL as Contributes_dmd_lateness, NULL as Shared_Supply, NULL as Uses_Order_Modifier, NULL as Pegged_to_Firm, dem.RECORD_SOURCE, to_number(NULL) AS START_QUANTITY, dem.EXPIRATION_DATE, msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE', msi.mrp_planning_code) AS MRP_PLANNING_CODE_TEXT, dem.ORIGINAL_ORG_ID, dem.ORIGINAL_INST_ID, dem.ORDER_DATE_TYPE_CODE, msc_get_name.lookup_meaning('ORA_MSC_ORDER_DATE_TYPE_CODE', DECODE( dem.ORDER_DATE_TYPE_CODE, NULL, 1, dem.ORDER_DATE_TYPE_CODE)) AS ORDER_DATE_TYPE_TEXT, dem.SCHEDULE_ARRIVAL_DATE, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL)as latest_acceptable_date, dem.PLANNED_ARRIVAL_DATE, to_number(NULL) AS SHIPMENT_ID, dem.SHIP_CALENDAR, NULL AS RECEIVING_CALENDAR, NULL AS INTRANSIT_CALENDAR, dem.INTRANSIT_LEAD_TIME, to_date(NULL) AS IMPLEMENT_DOCK_DATE, dem.IMPLEMENT_SHIP_DATE, dem.IMPLEMENT_ARRIVAL_DATE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 1, dem.request_date, null),dem.request_ship_date) AS REQUEST_SHIP_DATE, dem.PROMISE_SHIP_DATE, dem.days_late AS LATE_DAYS, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, 'MSC_DEMANDS' AS SOURCE_TABLE2, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) AS SCHEDULE_SHIP_DATE, NULL AS DEST_ORG_CODE, dem.quantity_by_due_date*NVL(dem.probability, 1) AS QTY_BY_DUE_DATE, dem.SHIP_SET_NAME , dem.ARRIVAL_SET_NAME, to_number(NULL) AS DEST_ORG_ID, to_number(NULL) AS DEST_INST_ID, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, DECODE(dem.zone_id, NULL, NULL, msc_get_name.get_zone_name(dem.zone_id)) AS ZONE, to_date(NULL) AS REQUESTED_COMPLETION_DATE, NULL AS LOTS_EXIST, NULL AS IMPLEMENT_SHIP_METHOD, to_date(NULL) AS ACTUAL_START_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, dem.SCHEDULE_DESIGNATOR_ID, dem.SALES_ORDER_LINE_ID, dem.SHIP_SET_ID, dem.ARRIVAL_SET_ID, to_date(NULL) AS FIRM_START_DATE, to_number(NULL) AS BILL_SEQUENCE_ID, to_number(NULL) AS ROUTING_SEQUENCE_ID, NULL AS COMMENTS, to_date(NULL) AS SUGGESTED_PICK_DATE, dem.LOAD_TYPE, msi.plan_id AS base_plan_id, msi.ROUNDING_CONTROL_TYPE, to_date(NULL) AS OLD_DOCK_DATE, NULL AS plan_cutoff_date, NULL AS plan_start_date, decode(msi.plan_id, -1, decode(dem.origination_type, 1030, nvl(msc_get_name.get_demand_reserved_quantity(dem.sales_order_line_id, dem.organization_id),dem.reserved_quantity), dem.reserved_quantity), dem.reserved_quantity) AS RESERVED_QUANTITY, TO_CHAR(NULL) AS CTB_FLAG , to_number(NULL) AS CTB_COMP_AVAIL_PERCENT , to_number(NULL) AS RTB_ORDER_QTY_PERCENT , to_date(NULL) AS CTB_EXPECTED_DATE , to_number(NULL) AS CTB_PRIORITY , dem.revised_dmd_date, dem.revised_dmd_priority, nvl(dem.ship_method, msc_get_name.get_ship_method(dem.carrier_id, dem.mode_of_transport, dem.service_level)) AS ship_method_text, dem.ORIG_FIRM_DATE , dem.ORIG_FIRM_QUANTITY, dem.SO_LINE_NUM, decode(dem.origination_type, 1030, dem.sales_order_number, dem.ORCH_ORDER_NUMBER) AS ORCH_ORDER_NUMBER, decode(dem.origination_type, 1030, nvl(dem.ORCH_ORDER_LINE_NUMBER, dem.SO_LINE_NUM), 1082, dem.SO_LINE_NUM, dem.ORCH_ORDER_LINE_NUMBER) as ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, NULL AS BMT_FLAG, msi.SIMULATION_SET_ID, NULL AS DROP_SHIP_DEST_TYPE, MSC_SPUI_COMMON.release_action ('MSC_DEMANDS',dem.plan_id,dem.ORGANIZATION_ID,msi.INVENTORY_ITEM_ID,dem.origination_type,dem.DEMAND_ID,msi.PURCHASING_ENABLED_FLAG,nvl(dem.reschedule_flag,2),0,null,msi.BUILD_IN_WIP_FLAG,dem.source_organization_id,ABS(dem.using_requirement_quantity),dem.FIRM_QUANTITY,dem.release_status,msi.wip_supply_type,msi.BOM_ITEM_TYPE, msi.PLANNING_MAKE_BUY_CODE,null,dem.original_quantity,null,dem.reserved_quantity,NULL,msi.PLANNER_CODE,DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2),dem.applied,to_number(null),msi.back_to_back_flag,msi.in_source_plan,dem.release_errors,null) as release_action, msi.back_to_back_flag, msc_get_name.msc_sr_lookup_meaning(dem.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, to_number(null) AS NET_SUPPLY_QTY_OVERRIDE, to_number(null) AS IMPLEMENT_BILL_SEQUENCE_ID, to_number(null) AS IMPLEMENT_ROUTING_SEQUENCE_ID, dem.CARRIER_ID, dem.MODE_OF_TRANSPORT, dem.SERVICE_LEVEL, to_number(null) AS IMPLEMENT_CARRIER_ID, to_number(null) AS IMPLEMENT_MODE_OF_TRANSPORT, to_number(null) AS IMPLEMENT_SERVICE_LEVEL, to_char(null) AS IMPLEMENT_SHIP_METHOD_TEXT, dem.CUSTOMER_PO_NUMBER, to_char(null) AS ITEM_STRUCTURE_NAME, to_char(null) AS WORK_DEFINITION, to_char(null) AS IMPLEMENT_ITEM_STRUCTURE, to_char(null) AS IMPLEMENT_WORK_DEFINITION, dem.DAYS_PAST_DUE, dem.QTY_SATISFIED_BY_RDD, nvl(dem.EXPENSE_TRANSFER,2) AS EXPENSE_TRANSFER, dem.parent_model_item_id AS PARENT_MODEL_ITEM_ID, msc_get_name.item_name(dem.parent_model_item_id, null, null) AS PARENT_MODEL_ITEM, NULL QTY_SCRAPPED, NULL EXPECTED_SCRAP_QTY, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) as QTY_COMPLETED, NULL FIRM_START_QUANTITY, msc_get_name.get_timezone_name(dem.organization_id) AS TIMEZONE_NAME, msc_get_name.get_timezone_code(dem.organization_id) AS TIMEZONE_CODE, msc_get_name.get_source_timezone_name(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) AS SOURCE_TIMEZONE_NAME, msc_get_name.get_source_timezone_code(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) AS SOURCE_TIMEZONE_CODE, msc_get_name.get_destination_timezone_name(dem.origination_type, dem.organization_id, null, dem.customer_site_id) AS DESTINATION_TIMEZONE_NAME, msc_get_name.get_destination_timezone_code(dem.origination_type, dem.organization_id, null, dem.customer_site_id) AS DESTINATION_TIMEZONE_CODE, NULL as ATTRIBUTE_CATEGORY, NULL as ATTRIBUTE_CHAR1, NULL as ATTRIBUTE_CHAR2, NULL as ATTRIBUTE_CHAR3, NULL as ATTRIBUTE_CHAR4, NULL as ATTRIBUTE_CHAR5, NULL as ATTRIBUTE_CHAR6, NULL as ATTRIBUTE_CHAR7, NULL as ATTRIBUTE_CHAR8, NULL as ATTRIBUTE_CHAR9, NULL as ATTRIBUTE_CHAR10, NULL as ATTRIBUTE_CHAR11, NULL as ATTRIBUTE_CHAR12, NULL as ATTRIBUTE_CHAR13, NULL as ATTRIBUTE_CHAR14, NULL as ATTRIBUTE_CHAR15, NULL as ATTRIBUTE_CHAR16, NULL as ATTRIBUTE_CHAR17, NULL as ATTRIBUTE_CHAR18, NULL as ATTRIBUTE_CHAR19, NULL as ATTRIBUTE_CHAR20, NULL as ATTRIBUTE_NUMBER1, NULL as ATTRIBUTE_NUMBER2, NULL as ATTRIBUTE_NUMBER3, NULL as ATTRIBUTE_NUMBER4, NULL as ATTRIBUTE_NUMBER5, NULL as ATTRIBUTE_NUMBER6, NULL as ATTRIBUTE_NUMBER7, NULL as ATTRIBUTE_NUMBER8, NULL as ATTRIBUTE_NUMBER9, NULL as ATTRIBUTE_NUMBER10, NULL as ATTRIBUTE_DATE1, NULL as ATTRIBUTE_DATE2, NULL as ATTRIBUTE_DATE3, NULL as ATTRIBUTE_DATE4, NULL as ATTRIBUTE_DATE5, NULL as ATTRIBUTE_DATE6, NULL as ATTRIBUTE_DATE7, NULL as ATTRIBUTE_DATE8, NULL as ATTRIBUTE_DATE9, NULL as ATTRIBUTE_DATE10, NULL as ATTRIBUTE_DATE11, NULL as ATTRIBUTE_DATE12, NULL as ATTRIBUTE_DATE13, NULL as ATTRIBUTE_DATE14, NULL as ATTRIBUTE_DATE15, NULL as ATTRIBUTE_DATE16, NULL as ATTRIBUTE_DATE17, NULL as ATTRIBUTE_DATE18, NULL as ATTRIBUTE_DATE19, NULL as ATTRIBUTE_DATE20, NULL as GLOBAL_ATTRIBUTE_CHAR1, NULL as GLOBAL_ATTRIBUTE_CHAR2, NULL as GLOBAL_ATTRIBUTE_CHAR3, NULL as GLOBAL_ATTRIBUTE_CHAR4, NULL as GLOBAL_ATTRIBUTE_CHAR5, NULL as GLOBAL_ATTRIBUTE_CHAR6, NULL as GLOBAL_ATTRIBUTE_CHAR7, NULL as GLOBAL_ATTRIBUTE_CHAR8, NULL as GLOBAL_ATTRIBUTE_CHAR9, NULL as GLOBAL_ATTRIBUTE_CHAR10, NULL as GLOBAL_ATTRIBUTE_CHAR11, NULL as GLOBAL_ATTRIBUTE_CHAR12, NULL as GLOBAL_ATTRIBUTE_CHAR13, NULL as GLOBAL_ATTRIBUTE_CHAR14, NULL as GLOBAL_ATTRIBUTE_CHAR15, NULL as GLOBAL_ATTRIBUTE_CHAR16, NULL as GLOBAL_ATTRIBUTE_CHAR17, NULL as GLOBAL_ATTRIBUTE_CHAR18, NULL as GLOBAL_ATTRIBUTE_CHAR19, NULL as GLOBAL_ATTRIBUTE_CHAR20, dem.GLOBAL_ATTRIBUTE_CHAR21, dem.GLOBAL_ATTRIBUTE_CHAR22, dem.GLOBAL_ATTRIBUTE_CHAR23, NULL as GLOBAL_ATTRIBUTE_NUMBER1, NULL as GLOBAL_ATTRIBUTE_NUMBER2, NULL as GLOBAL_ATTRIBUTE_NUMBER3, NULL as GLOBAL_ATTRIBUTE_NUMBER4, NULL as GLOBAL_ATTRIBUTE_NUMBER5, NULL as GLOBAL_ATTRIBUTE_NUMBER6, NULL as GLOBAL_ATTRIBUTE_NUMBER7, NULL as GLOBAL_ATTRIBUTE_NUMBER8, NULL as GLOBAL_ATTRIBUTE_NUMBER9, NULL as GLOBAL_ATTRIBUTE_NUMBER10, dem.GLOBAL_ATTRIBUTE_NUMBER11, dem.GLOBAL_ATTRIBUTE_NUMBER12, dem.GLOBAL_ATTRIBUTE_NUMBER13, dem.GLOBAL_ATTRIBUTE_NUMBER14, dem.GLOBAL_ATTRIBUTE_NUMBER15, dem.GLOBAL_ATTRIBUTE_NUMBER16, dem.GLOBAL_ATTRIBUTE_NUMBER17, dem.GLOBAL_ATTRIBUTE_NUMBER18, dem.GLOBAL_ATTRIBUTE_NUMBER19, dem.GLOBAL_ATTRIBUTE_NUMBER20, dem.GLOBAL_ATTRIBUTE_NUMBER21, dem.GLOBAL_ATTRIBUTE_NUMBER22, dem.GLOBAL_ATTRIBUTE_NUMBER23, dem.GLOBAL_ATTRIBUTE_NUMBER24, dem.GLOBAL_ATTRIBUTE_NUMBER25, dem.GLOBAL_ATTRIBUTE_NUMBER26, dem.GLOBAL_ATTRIBUTE_NUMBER27, dem.GLOBAL_ATTRIBUTE_NUMBER28, dem.GLOBAL_ATTRIBUTE_NUMBER29, dem.GLOBAL_ATTRIBUTE_NUMBER30, dem.GLOBAL_ATTRIBUTE_NUMBER31, dem.GLOBAL_ATTRIBUTE_NUMBER32, dem.GLOBAL_ATTRIBUTE_NUMBER33, dem.GLOBAL_ATTRIBUTE_NUMBER34, dem.GLOBAL_ATTRIBUTE_NUMBER35, dem.GLOBAL_ATTRIBUTE_NUMBER36, dem.GLOBAL_ATTRIBUTE_NUMBER37, dem.GLOBAL_ATTRIBUTE_NUMBER38, dem.GLOBAL_ATTRIBUTE_NUMBER39, dem.GLOBAL_ATTRIBUTE_NUMBER40, NULL as GLOBAL_ATTRIBUTE_DATE1, NULL as GLOBAL_ATTRIBUTE_DATE2, NULL as GLOBAL_ATTRIBUTE_DATE3, NULL as GLOBAL_ATTRIBUTE_DATE4, NULL as GLOBAL_ATTRIBUTE_DATE5, NULL as GLOBAL_ATTRIBUTE_DATE6, NULL as GLOBAL_ATTRIBUTE_DATE7, NULL as GLOBAL_ATTRIBUTE_DATE8, NULL as GLOBAL_ATTRIBUTE_DATE9, NULL as GLOBAL_ATTRIBUTE_DATE10, NULL as GLOBAL_ATTRIBUTE_DATE11, NULL as GLOBAL_ATTRIBUTE_DATE12, NULL as GLOBAL_ATTRIBUTE_DATE13, NULL as GLOBAL_ATTRIBUTE_DATE14, NULL as GLOBAL_ATTRIBUTE_DATE15, NULL as GLOBAL_ATTRIBUTE_DATE16, NULL as GLOBAL_ATTRIBUTE_DATE17, NULL as GLOBAL_ATTRIBUTE_DATE18, NULL as GLOBAL_ATTRIBUTE_DATE19, NULL as GLOBAL_ATTRIBUTE_DATE20, DECODE(NVL(kc.key_customer,0),0,1,2) AS IS_NON_KEY_CUSTOMER, dem.PRIMARY_COMPONENT_ID, dem.OP_SEQ_NUM AS OPERATION_SEQ_NUM, to_number(null) AS ALT_FACILITY_USED, to_number(null) AS ALT_SUPPLIER_USED, to_number(null) AS ALT_WORK_DEFINITION_USED, to_number(null) AS ALT_RESOURCE_USED, to_number(null) AS SUBSTITUTE_COMPONENT_USED, to_number(null) AS CANCELED, to_number(NULL) as total_output_quantity, to_date(NULL) as last_op_completion_date, to_number(NULL) as work_method_code, to_char(NULL) as process_name, to_char(NULL) as BATCH_UOM, to_number(NULL) as WORK_ORDER_SUB_TYPE, msi.segment_id, msc_get_name.segment_name(msi.segment_id) as SEGMENT_NAME, dem.subinv_flag, dem.source_subinventory_code, msi.hard_pegging_level, msc_get_name.org_code(dem.IMPLEMENT_ORG_ID) as implement_source_org, to_char(null) AS IMPLEMENT_SUPPLIER, to_char(null) AS IMPLEMENT_SUPPLIER_SITE, MSC_SPUI_COMMON.GET_ORG_CURRENCY_CODE(dem.ORGANIZATION_ID) AS ORG_CURRENCY_CODE, to_number(null) as QTY_REMAINING, msc_get_name.get_planner_desc(msi.PLANNER_CODE) AS PLANNER_DESCRIPTION, dem.issued_quantity AS ISSUED_QUANTITY, to_number(dem.configured_item) AS CONFIGURED_ITEM, msc_get_name.item_name(dem.configured_item, NULL, NULL) AS CONFIGURED_ITEM_NAME, dem.asset_number AS ASSET_NUMBER, to_number(null) AS CLUSTER_ID, null AS CLUSTER_NAME, to_number(null) AS REPL_INV_REBALANCE_FLAG, to_number(null) AS INIT_EXCESS_AT_SOURCE, to_number(null) AS INIT_SHORTAGE_AT_DEST, to_number(null) AS EXCESS_REDUCTION_AT_SRC, to_number(null) AS SHORTAGE_REDUCTION_AT_DEST, NVL(original_demand_id,demand_id) as original_transaction_id, to_date(null) AS HOLD_DATE, to_number(null) as order_status, to_char(null) as implement_location_code, dem.child_organization_id, msc_get_name.org_code(dem.child_organization_id) as child_organization_code, to_char(null) as original_subinventory_code, to_number(null) as UNDER_COMPLETED_FLAG, to_number(null) as SUBST_ITEM_ID, null as SUBST_ITEM_NAME, null as SUBST_ITEM_DESC, msc_get_name.item_desc(dem.original_item_id, dem.ORGANIZATION_ID, dem.PLAN_ID) as ORIGINAL_ITEM_DESC, dem.ATTRIBUTE_ROW_ID, to_number(null) as fg_order_type, to_date(null) as maturity_date, to_date(null) as constrained_start_date FROM msc_demands dem, msc_system_items msi, msc_key_customer kc WHERE msi.plan_id =NVL(dem.base_plan_id, dem.plan_id) AND msi.new_plan_id = -1 AND msi.simulation_set_id =-1 AND dem.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND dem.ORGANIZATION_ID = msi.ORGANIZATION_ID AND dem.customer_id = kc.customer_id(+)