MSC_ORDERS_SP_SIM_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

CONTRIBUTES_DMD_LATENESS SHARED_SUPPLY CONTRIBUTES_OVERLOAD CONSUMPTION_START_DATE USES_ORDER_MODIFIER LATEST_START_DATE PEGGED_TO_FIRM EARLIEST_START_DATE CREATED_BY CREATION_DATE FIRM_DATE FIRM_QUANTITY 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_CHAR21 GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR23 LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER SIMULATION_SET_ID SOURCE_TABLE TRANSACTION_ID NEW_RECORD DOCUMENT_ID DOCUMENT_TYPE SIM_PLAN_ID SIMULATION_SET_NAME HOLD_DATE ACTUAL_START_DATE ALTERNATE_BOM_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR APPLIED ARRIVAL_SET_ID ARRIVAL_SET_NAME BILL_SEQUENCE_ID BUCKET_TYPE BUILD_SEQUENCE BUYER_NAME COMMENTS CREATED_BY1 CREATION_DATE1 CUSTOMER_ID CUSTOMER_SITE_ID CUSTOMER_SITE_NAME DEMAND_CLASS DEMAND_PRIORITY OVERRIDE_DEMAND_PRIORITY DESIGNATOR_NAME DEST_INST_ID DEST_ORG_CODE DEST_ORG_ID DISPOSITION_ID DISPOSITION_STATUS_TYPE DMD_SATISFIED_DATE EXPIRATION_DATE FIRM_DATE1 FIRM_PLANNED_TYPE1 FIRM_QUANTITY1 IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_ARRIVAL_DATE IMPLEMENT_AS IMPLEMENT_AS_TEXT IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_DATE IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEST_INST_ID IMPLEMENT_DEST_ORG_CODE IMPLEMENT_DEST_ORG_ID IMPLEMENT_DOCK_DATE IMPLEMENT_DUE_DATE IMPLEMENT_EMPLOYEE_ID IMPLEMENT_FIRM IMPLEMENT_JOB_NAME IMPLEMENT_LINE_ID IMPLEMENT_LOCATION_ID IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROJECT_ID IMPLEMENT_QUANTITY_RATE IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_METHOD IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_STATUS_CODE IMPLEMENT_TASK_ID IMPLEMENT_UNIT_NUMBER IMPLEMENT_VENDOR_ID IMPLEMENT_VENDOR_SITE_ID IMPLEMENT_WIP_CLASS_CODE IMPLEMENTED_QUANTITY IN_SOURCE_PLAN INTRANSIT_CALENDAR INTRANSIT_LEAD_TIME ORDER_TYPE_TEXT FIRM_PLANNED_TYPE NEW_DUE_DATE ORDER_NUMBER CUSTOMER_NAME RELEASE_STATUS SHIP_DATE LAST_UNIT_COMPLETION_DATE LAST_UPDATE_DATE1 LAST_UPDATE_LOGIN1 LAST_UPDATED_BY1 LATEST_ACCEPTABLE_DATE LINE_ID LOAD_TYPE LOTS_EXIST NEED_BY_DATE NEW_DOCK_DATE NEW_ORDER_DATE NEW_START_DATE OLD_DOCK_DATE OLD_DUE_DATE OLD_NEED_BY_DATE OLD_ORDER_QUANTITY ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_TEXT ORDER_TYPE ORGANIZATION_ID ORIGINAL_INST_ID ORIGINAL_ITEM_ID ORIGINAL_ITEM_NAME ORIGINAL_ITEM_QTY ORIGINAL_NEED_BY_DATE ORIGINAL_ORG_ID ORIGINAL_QUANTITY PLAN_CUTOFF_DATE PLAN_ID PLAN_INSTANCE_ID PLAN_ORGANIZATION_ID PLAN_START_DATE PLANNED_ARRIVAL_DATE PROBABILITY PROCESS_SEQ_ID PROJECT_ID PROMISE_DATE PROMISE_SHIP_DATE QTY_BY_DUE_DATE QUANTITY QUANTITY_IN_PROCESS QUANTITY_RATE RECEIVING_CALENDAR RECORD_SOURCE RELEASE_ERRORS REPETITIVE_TYPE REQUEST_DATE REQUEST_SHIP_DATE REQUESTED_COMPLETION_DATE RESCHEDULE_DAYS RESCHEDULED_FLAG RESERVED_QUANTITY ROUTING_SEQUENCE_ID ROW_ID SALES_ORDER_LINE_ID SCHEDULE_ARRIVAL_DATE SCHEDULE_COMPRESSION_DAYS SCHEDULE_DESIGNATOR_ID SCHEDULE_GROUP_ID SCHEDULE_GROUP_NAME SCHEDULE_SHIP_DATE SELLING_PRICE SHIP_CALENDAR SHIP_METHOD SHIP_METHOD_TEXT SHIP_SET_ID SHIP_SET_NAME SHIP_TO_SITE_ID SHIP_TO_SITE_NAME SHIPMENT_ID SOURCE_DMD_PRIORITY SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_ID SOURCE_SR_INSTANCE_ID SOURCE_TABLE2 SOURCE_VENDOR_NAME SOURCE_VENDOR_SITE_CODE STATUS_CODE SUBINVENTORY_CODE SUBSTITUTE_COMPONENT_RANK SUGGESTED_PICK_DATE SUPPLIER_NAME SUPPLIER_SITE_CODE TASK_ID TRANSACTION_ID1 UNIT_NUMBER UNMET_QUANTITY USING_ASSEMBLY_ITEM_ID USING_ASSEMBLY_SEGMENTS VENDOR_ID VENDOR_SITE_ID START_QUANTITY WIP_STATUS_CODE WIP_STATUS_TEXT LATE_DAYS CTB_COMP_AVAIL_PERCENT CTB_EXPECTED_DATE CTB_FLAG CTB_PRIORITY FIRM_START_DATE RTB_ORDER_QTY_PERCENT REVISED_DMD_DATE REVISED_DMD_PRIORITY ORIG_FIRM_DATE ORIG_FIRM_QUANTITY ZONE SO_LINE_NUM ORCH_ORDER_NUMBER ORCH_ORDER_LINE_NUMBER FULFILLMENT_LINE_NUM BMT_FLAG DROP_SHIP_DEST_TYPE DEMAND_CLASS_CODE NET_SUPPLY_QTY_OVERRIDE LOT_NUMBER 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 DAYS_PAST_DUE QTY_SATISFIED_BY_RDD EXPENSE_TRANSFER PARENT_MODEL_ITEM_ID PARENT_MODEL_ITEM INVENTORY_ITEM_ID NEW_ORDER_QUANTITY SOURCE_SUPPLIER_ID PURCH_LINE_NUM TO_LINE_NUMBER TO_LINE_ID WIP_ENTITY_NAME PO_LINE_LOCATION_ID PE_PLAN_ID PE_ROUTING_SEQUENCE_ID PE_BILL_SEQUENCE_ID ORG_FIRM_FLAG USING_REQUIREMENT_QUANTITY DAILY_DEMAND_RATE OLD_DEMAND_QUANTITY ORIGINATION_TYPE FIRM_START_QUANTITY QTY_SCRAPPED EXPECTED_SCRAP_QTY QTY_COMPLETED BASE_PLAN_ID TIMEZONE_NAME TIMEZONE_CODE SOURCE_TIMEZONE_NAME SOURCE_TIMEZONE_CODE DESTINATION_TIMEZONE_NAME DESTINATION_TIMEZONE_CODE 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 FIRM_START_QUANTITY1 GLOBAL_ATTR_NUMBER11S GLOBAL_ATTR_NUMBER12S GLOBAL_ATTR_NUMBER13S GLOBAL_ATTR_NUMBER14S GLOBAL_ATTR_NUMBER15S GLOBAL_ATTR_NUMBER16S GLOBAL_ATTR_NUMBER17S GLOBAL_ATTR_NUMBER18S GLOBAL_ATTR_NUMBER19S GLOBAL_ATTR_NUMBER20S GLOBAL_ATTR_NUMBER21S GLOBAL_ATTR_NUMBER22S GLOBAL_ATTR_NUMBER23S GLOBAL_ATTR_NUMBER24S GLOBAL_ATTR_NUMBER25S GLOBAL_ATTR_NUMBER26S GLOBAL_ATTR_NUMBER27S GLOBAL_ATTR_NUMBER28S GLOBAL_ATTR_NUMBER29S GLOBAL_ATTR_NUMBER30S GLOBAL_ATTR_NUMBER31S GLOBAL_ATTR_NUMBER32S GLOBAL_ATTR_NUMBER33S GLOBAL_ATTR_NUMBER34S GLOBAL_ATTR_NUMBER35S GLOBAL_ATTR_NUMBER36S GLOBAL_ATTR_NUMBER37S GLOBAL_ATTR_NUMBER38S GLOBAL_ATTR_NUMBER39S GLOBAL_ATTR_NUMBER40S GLOBAL_ATTRIBUTE_CHAR21S GLOBAL_ATTRIBUTE_CHAR22S GLOBAL_ATTRIBUTE_CHAR23S IMPLEMENT_SOURCE_ORG IMPLEMENT_SUPPLIER IMPLEMENT_SUPPLIER_SITE ORG_CURRENCY_CODE QTY_REMAINING ISSUED_QUANTITY CONFIGURED_ITEM CONFIGURED_ITEM_NAME ASSET_NUMBER DROP_SHIP_CUSTOMER DROP_SHIP_CUSTOMER_SITE RECEIPT_NUMBER REVISION DELIVERY_PRICE SCHEDULE_LINE_NUMBER SHIPMENT_LINE_NUMBER SHIPMENT_HEADER_NUMBER SOURCE_SUBINVENTORY_CODE ALLOW_SPLITS ALLOW_SUBSTITUTION COMPLETED_QUANTITY CUSTOMER_PO_LINE_NUMBER CUSTOMER_PO_SCHEDULE_NUMBER DELIVERY_COST DELIVERY_LEAD_TIME EARLIEST_ACCEPT_ARRIVAL_DATE EARLIEST_ACCEPT_SHIP_DATE FULFILLMENT_COST GOP_REFERENCE_ID INCLUDED_ITEMS_INDICATOR INQUIRY_DEMAND ITEM_SUB_TYPE_CODE ITEM_TYPE_CODE LATEST_ACCEPTABLE_ARRIVAL_DATE LATEST_ACCEPTABLE_SHIP_DATE MINIMUM_PERCENTAGE_FOR_SPLIT MINIMUM_QUANTITY_FOR_SPLIT MINIMUM_REMAINING_SHELF_LIFE ORDER_MARGIN PARENT_FULFILLMENT_LINE PROMISING_SYSTEM ROOT_FULFILLMENT_LINE SALES_REPRESENTATIVE_CONTACT SHIPPING_PREFERENCE SUPPLIER_SITE_SOURCE_SYSTEM HOLD_DATE1 IMPLEMENT_LOCATION_CODE MATURITY_DATE MATURITY_DATE1

Query

SQL_Statement

SELECT /*+ORDERED */ sup.CONTRIBUTES_DMD_LATENESS, sup.SHARED_SUPPLY, sup.CONTRIBUTES_OVERLOAD, sup.CONSUMPTION_START_DATE, sup.USES_ORDER_MODIFIER, sup.LATEST_START_DATE, sup.PEGGED_TO_FIRM, sup.EARLIEST_START_DATE, MscOrderUpdateEO.CREATED_BY, MscOrderUpdateEO.CREATION_DATE, MscOrderUpdateEO.FIRM_DATE, MscOrderUpdateEO.FIRM_QUANTITY, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER11, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER12, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER13, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER14, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER15, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER16, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER17, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER18, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER19, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER20, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER23, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER24, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER25, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER26, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER27, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER28, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER29, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER30, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER31, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER32, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER33, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER34, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER35, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER36, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER37, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER38, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER39, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER40, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR23, MscOrderUpdateEO.LAST_UPDATE_DATE, MscOrderUpdateEO.LAST_UPDATE_LOGIN, MscOrderUpdateEO.LAST_UPDATED_BY, MscOrderUpdateEO.OBJECT_VERSION_NUMBER, MscOrderUpdateEO.SIMULATION_SET_ID, MscOrderUpdateEO.SOURCE_TABLE, MscOrderUpdateEO.TRANSACTION_ID, MscOrderUpdateEO.NEW_RECORD, MscOrderUpdateEO.DOCUMENT_ID, MscOrderUpdateEO.DOCUMENT_TYPE, MscOrderUpdateEO.SIM_PLAN_ID, MscOrderUpdateEO.SIMULATION_SET_ID as SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, SUP.ACTUAL_START_DATE, SUP.ALTERNATE_BOM_DESIGNATOR, SUP.ALTERNATE_ROUTING_DESIGNATOR, SUP.APPLIED, to_number(NULL) AS ARRIVAL_SET_ID, NULL AS ARRIVAL_SET_NAME, SUP.BILL_SEQUENCE_ID, NULL AS BUCKET_TYPE, 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, NULL AS BUYER_NAME, msc_get_name.get_order_Comments(sup.plan_id, 'SUPPLY', sup.TRANSACTION_ID) AS COMMENTS, SUP.CREATED_BY AS CREATED_BY1, SUP.CREATION_DATE AS CREATION_DATE1, nvl(sup.drop_ship_cust_id, sup.customer_id) AS CUSTOMER_ID, 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, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) AS DEMAND_CLASS, sup.schedule_priority AS DEMAND_PRIORITY, NULL AS OVERRIDE_DEMAND_PRIORITY, sup.schedule_designator AS DESIGNATOR_NAME, to_number(NULL) AS DEST_INST_ID, NULL AS DEST_ORG_CODE, to_number(NULL) AS DEST_ORG_ID, SUP.DISPOSITION_ID, SUP.DISPOSITION_STATUS_TYPE, to_date(NULL) AS DMD_SATISFIED_DATE, SUP.EXPIRATION_DATE, SUP.FIRM_DATE AS FIRM_DATE1, SUP.FIRM_PLANNED_TYPE AS FIRM_PLANNED_TYPE1, SUP.FIRM_QUANTITY AS FIRM_QUANTITY1, SUP.IMPLEMENT_ALTERNATE_BOM, SUP.IMPLEMENT_ALTERNATE_ROUTING, to_date(NULL) AS IMPLEMENT_ARRIVAL_DATE, 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, SUP.IMPLEMENT_BUILD_SEQUENCE, SUP.IMPLEMENT_DATE, SUP.IMPLEMENT_DEMAND_CLASS, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, SUP.IMPLEMENT_DOCK_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, SUP.IMPLEMENT_EMPLOYEE_ID, SUP.IMPLEMENT_FIRM, SUP.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, SUP.IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, SUP.IMPLEMENT_PROJECT_ID, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) AS IMPLEMENT_QUANTITY_RATE, SUP.IMPLEMENT_SCHEDULE_GROUP_ID, SUP.IMPLEMENT_SHIP_DATE, SUP.IMPLEMENT_SHIP_METHOD, SUP.IMPLEMENT_SOURCE_ORG_ID, NULL AS IMPLEMENT_SR_INSTANCE_ID, SUP.IMPLEMENT_STATUS_CODE, SUP.IMPLEMENT_TASK_ID, SUP.IMPLEMENT_UNIT_NUMBER, sup.implement_supplier_id AS IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id AS IMPLEMENT_VENDOR_SITE_ID, SUP.IMPLEMENT_WIP_CLASS_CODE, SUP.IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) AS IN_SOURCE_PLAN, SUP.INTRANSIT_CALENDAR, SUP.INTRANSIT_LEAD_TIME, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) AS ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, sup.NEW_SCHEDULE_DATE AS NEW_DUE_DATE, 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, msc_get_name.customer(nvl(sup.drop_ship_cust_id, sup.customer_id)) AS CUSTOMER_NAME, NVL(sup.RELEASE_STATUS,-1) AS RELEASE_STATUS, sup.new_ship_date AS SHIP_DATE, SUP.LAST_UNIT_COMPLETION_DATE, SUP.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1, SUP.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN1, SUP.LAST_UPDATED_BY AS LAST_UPDATED_BY1, to_date(NULL) AS LATEST_ACCEPTABLE_DATE, SUP.LINE_ID, SUP.LOAD_TYPE, NULL AS LOTS_EXIST, SUP.NEED_BY_DATE, SUP.NEW_DOCK_DATE, NVL(sup.NEW_ORDER_PLACEMENT_DATE , sup.firm_date) AS NEW_ORDER_DATE, sup.NEW_WIP_START_DATE AS NEW_START_DATE, SUP.OLD_DOCK_DATE, sup.OLD_SCHEDULE_DATE AS OLD_DUE_DATE, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) AS OLD_NEED_BY_DATE, SUP.OLD_ORDER_QUANTITY, to_number(NULL) AS ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) AS ORDER_DATE_TYPE_TEXT, SUP.ORDER_TYPE, SUP.ORGANIZATION_ID, to_number(NULL) AS ORIGINAL_INST_ID, to_number(NULL) AS ORIGINAL_ITEM_ID, NULL AS ORIGINAL_ITEM_NAME, to_number(NULL) AS ORIGINAL_ITEM_QTY, SUP.ORIGINAL_NEED_BY_DATE, to_number(NULL) AS ORIGINAL_ORG_ID, SUP.ORIGINAL_QUANTITY, to_date(NULL) AS PLAN_CUTOFF_DATE, SUP.PLAN_ID, to_number(NULL) AS PLAN_INSTANCE_ID, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_date(NULL) AS PLAN_START_DATE, to_date(NULL) AS PLANNED_ARRIVAL_DATE, to_number(NULL) AS PROBABILITY, SUP.PROCESS_SEQ_ID, SUP.PROJECT_ID, sup.promised_date AS PROMISE_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) AS PROMISE_SHIP_DATE, to_number(NULL) AS QTY_BY_DUE_DATE, sup.new_order_quantity AS QUANTITY, SUP.QUANTITY_IN_PROCESS, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) AS QUANTITY_RATE, SUP.RECEIVING_CALENDAR, SUP.RECORD_SOURCE, SUP.RELEASE_ERRORS, NULL AS REPETITIVE_TYPE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) AS REQUEST_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) AS REQUEST_SHIP_DATE, SUP.REQUESTED_COMPLETION_DATE, SUP.RESCHEDULE_DAYS, sup.RESCHEDULE_FLAG AS RESCHEDULED_FLAG, sup.reserved_quantity, SUP.ROUTING_SEQUENCE_ID, SUP.ROWID AS ROW_ID, NULL AS SALES_ORDER_LINE_ID, to_date(NULL) AS SCHEDULE_ARRIVAL_DATE, sup.schedule_compress_days AS SCHEDULE_COMPRESSION_DAYS, SUP.SCHEDULE_DESIGNATOR_ID AS SCHEDULE_DESIGNATOR_ID, 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.SCHEDULE_GROUP_NAME, to_date(NULL) AS SCHEDULE_SHIP_DATE, to_number(NULL) AS SELLING_PRICE, SUP.SHIP_CALENDAR, SUP.SHIP_METHOD, nvl(sup.ship_method, msc_get_name.get_ship_method(sup.carrier_id, sup.mode_of_transport, sup.service_level)) AS ship_method_text, to_number(NULL) AS ship_set_id, NULL AS SHIP_SET_NAME, to_number(NULL) AS SHIP_TO_SITE_ID, NULL AS SHIP_TO_SITE_NAME, SUP.SHIPMENT_ID, to_number(NULL) AS SOURCE_DMD_PRIORITY, msc_get_name.org_code(sup.source_organization_id) AS SOURCE_ORGANIZATION_CODE, SUP.SOURCE_ORGANIZATION_ID, NULL AS SOURCE_SR_INSTANCE_ID, 'MSC_SUPPLIES' AS SOURCE_TABLE2, 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.wip_status_code AS STATUS_CODE, SUP.SUBINVENTORY_CODE, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, to_date(NULL) AS SUGGESTED_PICK_DATE, NULL AS SUPPLIER_NAME, NULL AS SUPPLIER_SITE_CODE, SUP.TASK_ID AS TASK_ID, sup.TRANSACTION_ID AS TRANSACTION_ID1, SUP.UNIT_NUMBER, to_number(NULL) AS UNMET_QUANTITY, to_number(NULL) AS USING_ASSEMBLY_ITEM_ID, NULL AS USING_ASSEMBLY_SEGMENTS, sup.supplier_id AS VENDOR_ID, sup.supplier_site_id AS VENDOR_SITE_ID, SUP.START_QUANTITY, SUP.WIP_STATUS_CODE, msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) AS WIP_STATUS_TEXT, SUP.days_late AS LATE_DAYS, SUP.CTB_COMP_AVAIL_PERCENT, SUP.CTB_EXPECTED_DATE, SUP.CTB_FLAG, sup.CTB_PRIOIRTY AS CTB_PRIORITY, SUP.FIRM_START_DATE, SUP.RTB_ORDER_QTY_PERCENT, to_date(NULL) AS REVISED_DMD_DATE, to_number(NULL) AS REVISED_DMD_PRIORITY, SUP.ORIG_FIRM_DATE, SUP.ORIG_FIRM_QUANTITY, msc_get_name.get_zone_name(sup.zone_id) AS ZONE, 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, SUP.DROP_SHIP_DEST_TYPE, msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, SUP.NET_SUPPLY_QTY_OVERRIDE, SUP.LOT_NUMBER, 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, 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.INVENTORY_ITEM_ID, sup.new_order_quantity, sup.SOURCE_SUPPLIER_ID, sup.PURCH_LINE_NUM, sup.TO_LINE_NUMBER, sup.TO_LINE_ID, sup.WIP_ENTITY_NAME, sup.PO_LINE_LOCATION_ID, pe.plan_id as pe_plan_id, pe.routing_sequence_id as pe_routing_sequence_id, pe.bill_sequence_id as pe_bill_sequence_id, to_number(null) AS ORG_FIRM_FLAG, to_number(null) AS using_requirement_quantity, to_number(null) AS DAILY_DEMAND_RATE, to_number(null) AS OLD_DEMAND_QUANTITY, to_number(null) AS ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity , sup.qty_scrapped AS QTY_SCRAPPED,sup.expected_scrap_qty AS EXPECTED_SCRAP_QTY, sup.qty_completed AS QTY_COMPLETED, SUP.BASE_PLAN_ID, 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.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 as WORK_ORDER_SUB_TYPE, sup.firm_start_quantity as FIRM_START_QUANTITY1, sup.global_attribute_number11 as GLOBAL_ATTR_NUMBER11S, sup.global_attribute_number12 as GLOBAL_ATTR_NUMBER12S, sup.global_attribute_number13 as GLOBAL_ATTR_NUMBER13S, sup.global_attribute_number14 as GLOBAL_ATTR_NUMBER14S, sup.global_attribute_number15 as GLOBAL_ATTR_NUMBER15S, sup.global_attribute_number16 as GLOBAL_ATTR_NUMBER16S, sup.global_attribute_number17 as GLOBAL_ATTR_NUMBER17S, sup.global_attribute_number18 as GLOBAL_ATTR_NUMBER18S, sup.global_attribute_number19 as GLOBAL_ATTR_NUMBER19S, sup.global_attribute_number20 as GLOBAL_ATTR_NUMBER20S, sup.global_attribute_number21 as GLOBAL_ATTR_NUMBER21S, sup.global_attribute_number22 as GLOBAL_ATTR_NUMBER22S, sup.global_attribute_number23 as GLOBAL_ATTR_NUMBER23S, sup.global_attribute_number24 as GLOBAL_ATTR_NUMBER24S, sup.global_attribute_number25 as GLOBAL_ATTR_NUMBER25S, sup.global_attribute_number26 as GLOBAL_ATTR_NUMBER26S, sup.global_attribute_number27 as GLOBAL_ATTR_NUMBER27S, sup.global_attribute_number28 as GLOBAL_ATTR_NUMBER28S, sup.global_attribute_number29 as GLOBAL_ATTR_NUMBER29S, sup.global_attribute_number30 as GLOBAL_ATTR_NUMBER30S, sup.global_attribute_number31 as GLOBAL_ATTR_NUMBER31S, sup.global_attribute_number32 as GLOBAL_ATTR_NUMBER32S, sup.global_attribute_number33 as GLOBAL_ATTR_NUMBER33S, sup.global_attribute_number34 as GLOBAL_ATTR_NUMBER34S, sup.global_attribute_number35 as GLOBAL_ATTR_NUMBER35S, sup.global_attribute_number36 as GLOBAL_ATTR_NUMBER36S, sup.global_attribute_number37 as GLOBAL_ATTR_NUMBER37S, sup.global_attribute_number38 as GLOBAL_ATTR_NUMBER38S, sup.global_attribute_number39 as GLOBAL_ATTR_NUMBER39S, sup.global_attribute_number40 as GLOBAL_ATTR_NUMBER40S, sup.GLOBAL_ATTRIBUTE_CHAR21 as GLOBAL_ATTRIBUTE_CHAR21S, sup.GLOBAL_ATTRIBUTE_CHAR22 as GLOBAL_ATTRIBUTE_CHAR22S, sup.GLOBAL_ATTRIBUTE_CHAR23 as GLOBAL_ATTRIBUTE_CHAR23S, 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, sup.quantity_issued AS ISSUED_QUANTITY, to_number(null) AS CONFIGURED_ITEM, to_char(null) AS CONFIGURED_ITEM_NAME, sup.asset_number, msc_get_name.customer(sup.drop_ship_cust_id) as drop_ship_customer, msc_get_name.customer_site(sup.drop_ship_cust_site_id) as drop_ship_customer_site, sup.receipt_num as receipt_number, sup.revision, sup.delivery_price, sup.schedule_line_num as schedule_line_number, sup.shipment_line_num as shipment_line_number, sup.shipment_header_num as shipment_header_number, sup.source_subinventory_code, to_number(null) AS ALLOW_SPLITS, to_number(null) AS ALLOW_SUBSTITUTION, to_number(null) AS COMPLETED_QUANTITY, null as CUSTOMER_PO_LINE_NUMBER, null as CUSTOMER_PO_SCHEDULE_NUMBER, to_number(null) AS DELIVERY_COST, to_number(null) AS DELIVERY_LEAD_TIME, to_date(NULL) AS EARLIEST_ACCEPT_ARRIVAL_DATE, to_date(NULL) AS EARLIEST_ACCEPT_SHIP_DATE, to_number(null) AS FULFILLMENT_COST, null AS GOP_REFERENCE_ID, to_number(null) AS Included_Items_Indicator, to_number(null) AS INQUIRY_DEMAND, null as ITEM_SUB_TYPE_CODE, null as ITEM_TYPE_CODE, to_date(NULL) as LATEST_ACCEPTABLE_ARRIVAL_DATE, to_date(NULL) as LATEST_ACCEPTABLE_SHIP_DATE, to_number(null) AS Minimum_Percentage_For_Split, to_number(null) AS Minimum_Quantity_For_Split, to_number(null) AS Minimum_Remaining_Shelf_Life, to_number(null) AS ORDER_MARGIN, null as PARENT_FULFILLMENT_LINE, null as PROMISING_SYSTEM, null as ROOT_FULFILLMENT_LINE, null as Sales_Representative_Contact, null as SHIPPING_PREFERENCE, to_number(null) AS SUPPLIER_SITE_SOURCE_SYSTEM, sup.HOLD_DATE AS HOLD_DATE1, msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) as implement_location_code, MscOrderUpdateEO.MATURITY_DATE as MATURITY_DATE, sup.MATURITY_DATE as MATURITY_DATE1 FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_SUPPLIES SUP left outer join (SELECT NVL(mp1.plan_id, -1) as plan_id, pe1.routing_sequence_id, pe1.bill_sequence_id , pe1.process_Sequence_id FROM msc_process_effectivity pe1 left outer join msc_plan_definitions mp1 on pe1.plan_id = NVL(decode(mp1.compile_designator, 'SimPlan', mp1.plan_id, mp1.base_plan_id),mp1.plan_id) ) pe on (sup.plan_id=pe.plan_id and sup.process_seq_id=pe.process_sequence_id) WHERE ( MscOrderUpdateEO.sim_plan_id= SUP.plan_id AND MscOrderUpdateEO.TRANSACTION_ID = SUP.TRANSACTION_ID AND MscOrderUpdateEO.SOURCE_TABLE = 'MSC_SUPPLIES' AND MscOrderUpdateEO.new_record=1 ) union all SELECT /*+ORDERED */ sup.CONTRIBUTES_DMD_LATENESS, sup.SHARED_SUPPLY, sup.CONTRIBUTES_OVERLOAD, sup.CONSUMPTION_START_DATE, sup.USES_ORDER_MODIFIER, sup.LATEST_START_DATE, sup.PEGGED_TO_FIRM, sup.EARLIEST_START_DATE, MscOrderUpdateEO.CREATED_BY, MscOrderUpdateEO.CREATION_DATE, MscOrderUpdateEO.FIRM_DATE, MscOrderUpdateEO.FIRM_QUANTITY, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER11, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER12, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER13, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER14, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER15, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER16, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER17, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER18, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER19, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER20, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER23, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER24, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER25, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER26, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER27, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER28, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER29, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER30, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER31, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER32, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER33, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER34, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER35, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER36, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER37, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER38, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER39, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER40, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR23, MscOrderUpdateEO.LAST_UPDATE_DATE, MscOrderUpdateEO.LAST_UPDATE_LOGIN, MscOrderUpdateEO.LAST_UPDATED_BY, MscOrderUpdateEO.OBJECT_VERSION_NUMBER, MscOrderUpdateEO.SIMULATION_SET_ID, MscOrderUpdateEO.SOURCE_TABLE, MscOrderUpdateEO.TRANSACTION_ID, MscOrderUpdateEO.NEW_RECORD, MscOrderUpdateEO.DOCUMENT_ID, MscOrderUpdateEO.DOCUMENT_TYPE, MscOrderUpdateEO.SIM_PLAN_ID, MscOrderUpdateEO.SIMULATION_SET_ID as SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, SUP.ACTUAL_START_DATE, SUP.ALTERNATE_BOM_DESIGNATOR, SUP.ALTERNATE_ROUTING_DESIGNATOR, SUP.APPLIED, to_number(NULL) AS ARRIVAL_SET_ID, NULL AS ARRIVAL_SET_NAME, SUP.BILL_SEQUENCE_ID, NULL AS BUCKET_TYPE, 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, NULL AS BUYER_NAME, msc_get_name.get_order_Comments(sup.plan_id, 'SUPPLY', sup.TRANSACTION_ID) AS COMMENTS, SUP.CREATED_BY AS CREATED_BY1, SUP.CREATION_DATE AS CREATION_DATE1, nvl(sup.drop_ship_cust_id, sup.customer_id) AS CUSTOMER_ID, 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, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) AS DEMAND_CLASS, sup.schedule_priority AS DEMAND_PRIORITY, NULL AS OVERRIDE_DEMAND_PRIORITY, sup.schedule_designator AS DESIGNATOR_NAME, to_number(NULL) AS DEST_INST_ID, NULL AS DEST_ORG_CODE, to_number(NULL) AS DEST_ORG_ID, SUP.DISPOSITION_ID, SUP.DISPOSITION_STATUS_TYPE, to_date(NULL) AS DMD_SATISFIED_DATE, SUP.EXPIRATION_DATE, SUP.FIRM_DATE AS FIRM_DATE1, SUP.FIRM_PLANNED_TYPE AS FIRM_PLANNED_TYPE1, SUP.FIRM_QUANTITY AS FIRM_QUANTITY1, SUP.IMPLEMENT_ALTERNATE_BOM, SUP.IMPLEMENT_ALTERNATE_ROUTING, to_date(NULL) AS IMPLEMENT_ARRIVAL_DATE, 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, SUP.IMPLEMENT_BUILD_SEQUENCE, SUP.IMPLEMENT_DATE, SUP.IMPLEMENT_DEMAND_CLASS, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, SUP.IMPLEMENT_DOCK_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, SUP.IMPLEMENT_EMPLOYEE_ID, SUP.IMPLEMENT_FIRM, SUP.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, SUP.IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, SUP.IMPLEMENT_PROJECT_ID, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) AS IMPLEMENT_QUANTITY_RATE, SUP.IMPLEMENT_SCHEDULE_GROUP_ID, SUP.IMPLEMENT_SHIP_DATE, SUP.IMPLEMENT_SHIP_METHOD, SUP.IMPLEMENT_SOURCE_ORG_ID, NULL AS IMPLEMENT_SR_INSTANCE_ID, SUP.IMPLEMENT_STATUS_CODE, SUP.IMPLEMENT_TASK_ID, SUP.IMPLEMENT_UNIT_NUMBER, sup.implement_supplier_id AS IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id AS IMPLEMENT_VENDOR_SITE_ID, SUP.IMPLEMENT_WIP_CLASS_CODE, SUP.IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) AS IN_SOURCE_PLAN, SUP.INTRANSIT_CALENDAR, SUP.INTRANSIT_LEAD_TIME, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) AS ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, sup.NEW_SCHEDULE_DATE AS NEW_DUE_DATE, 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, msc_get_name.customer(nvl(sup.drop_ship_cust_id, sup.customer_id)) AS CUSTOMER_NAME, NVL(sup.RELEASE_STATUS,-1) AS RELEASE_STATUS, sup.new_ship_date AS SHIP_DATE, SUP.LAST_UNIT_COMPLETION_DATE, SUP.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1, SUP.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN1, SUP.LAST_UPDATED_BY AS LAST_UPDATED_BY1, to_date(NULL) AS LATEST_ACCEPTABLE_DATE, SUP.LINE_ID, SUP.LOAD_TYPE, NULL AS LOTS_EXIST, SUP.NEED_BY_DATE, SUP.NEW_DOCK_DATE, NVL(sup.NEW_ORDER_PLACEMENT_DATE , sup.firm_date) AS NEW_ORDER_DATE, sup.NEW_WIP_START_DATE AS NEW_START_DATE, SUP.OLD_DOCK_DATE, sup.OLD_SCHEDULE_DATE AS OLD_DUE_DATE, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) AS OLD_NEED_BY_DATE, SUP.OLD_ORDER_QUANTITY, to_number(NULL) AS ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) AS ORDER_DATE_TYPE_TEXT, SUP.ORDER_TYPE, SUP.ORGANIZATION_ID, to_number(NULL) AS ORIGINAL_INST_ID, to_number(NULL) AS ORIGINAL_ITEM_ID, NULL AS ORIGINAL_ITEM_NAME, to_number(NULL) AS ORIGINAL_ITEM_QTY, SUP.ORIGINAL_NEED_BY_DATE, to_number(NULL) AS ORIGINAL_ORG_ID, SUP.ORIGINAL_QUANTITY, to_date(NULL) AS PLAN_CUTOFF_DATE, SUP.PLAN_ID, to_number(NULL) AS PLAN_INSTANCE_ID, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_date(NULL) AS PLAN_START_DATE, to_date(NULL) AS PLANNED_ARRIVAL_DATE, to_number(NULL) AS PROBABILITY, SUP.PROCESS_SEQ_ID, SUP.PROJECT_ID, sup.promised_date AS PROMISE_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) AS PROMISE_SHIP_DATE, to_number(NULL) AS QTY_BY_DUE_DATE, sup.new_order_quantity AS QUANTITY, SUP.QUANTITY_IN_PROCESS, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) AS QUANTITY_RATE, SUP.RECEIVING_CALENDAR, SUP.RECORD_SOURCE, SUP.RELEASE_ERRORS, NULL AS REPETITIVE_TYPE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) AS REQUEST_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) AS REQUEST_SHIP_DATE, SUP.REQUESTED_COMPLETION_DATE, SUP.RESCHEDULE_DAYS, sup.RESCHEDULE_FLAG AS RESCHEDULED_FLAG, sup.reserved_quantity, SUP.ROUTING_SEQUENCE_ID, SUP.ROWID AS ROW_ID, NULL AS SALES_ORDER_LINE_ID, to_date(NULL) AS SCHEDULE_ARRIVAL_DATE, sup.schedule_compress_days AS SCHEDULE_COMPRESSION_DAYS, SUP.SCHEDULE_DESIGNATOR_ID AS SCHEDULE_DESIGNATOR_ID, 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.SCHEDULE_GROUP_NAME, to_date(NULL) AS SCHEDULE_SHIP_DATE, to_number(NULL) AS SELLING_PRICE, SUP.SHIP_CALENDAR, SUP.SHIP_METHOD, nvl(sup.ship_method, msc_get_name.get_ship_method(sup.carrier_id, sup.mode_of_transport, sup.service_level)) AS ship_method_text, to_number(NULL) AS ship_set_id, NULL AS SHIP_SET_NAME, to_number(NULL) AS SHIP_TO_SITE_ID, NULL AS SHIP_TO_SITE_NAME, SUP.SHIPMENT_ID, to_number(NULL) AS SOURCE_DMD_PRIORITY, msc_get_name.org_code(sup.source_organization_id) AS SOURCE_ORGANIZATION_CODE, SUP.SOURCE_ORGANIZATION_ID, NULL AS SOURCE_SR_INSTANCE_ID, 'MSC_SUPPLIES' AS SOURCE_TABLE2, 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.wip_status_code AS STATUS_CODE, SUP.SUBINVENTORY_CODE, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, to_date(NULL) AS SUGGESTED_PICK_DATE, NULL AS SUPPLIER_NAME, NULL AS SUPPLIER_SITE_CODE, SUP.TASK_ID AS TASK_ID, sup.TRANSACTION_ID AS TRANSACTION_ID1, SUP.UNIT_NUMBER, to_number(NULL) AS UNMET_QUANTITY, to_number(NULL) AS USING_ASSEMBLY_ITEM_ID, NULL AS USING_ASSEMBLY_SEGMENTS, sup.supplier_id AS VENDOR_ID, sup.supplier_site_id AS VENDOR_SITE_ID, SUP.START_QUANTITY, SUP.WIP_STATUS_CODE, msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) AS WIP_STATUS_TEXT, SUP.days_late AS LATE_DAYS, SUP.CTB_COMP_AVAIL_PERCENT, SUP.CTB_EXPECTED_DATE, SUP.CTB_FLAG, sup.CTB_PRIOIRTY AS CTB_PRIORITY, SUP.FIRM_START_DATE, SUP.RTB_ORDER_QTY_PERCENT, to_date(NULL) AS REVISED_DMD_DATE, to_number(NULL) AS REVISED_DMD_PRIORITY, SUP.ORIG_FIRM_DATE, SUP.ORIG_FIRM_QUANTITY, msc_get_name.get_zone_name(sup.zone_id) AS ZONE, 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, SUP.DROP_SHIP_DEST_TYPE, msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, SUP.NET_SUPPLY_QTY_OVERRIDE, SUP.LOT_NUMBER, 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, 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.INVENTORY_ITEM_ID, sup.new_order_quantity, sup.SOURCE_SUPPLIER_ID, sup.PURCH_LINE_NUM, sup.TO_LINE_NUMBER, sup.TO_LINE_ID, sup.WIP_ENTITY_NAME, sup.PO_LINE_LOCATION_ID, pe.plan_id as pe_plan_id, pe.routing_sequence_id as pe_routing_sequence_id, pe.bill_sequence_id as pe_bill_sequence_id, to_number(null) AS ORG_FIRM_FLAG, to_number(null) AS using_requirement_quantity, to_number(null) AS DAILY_DEMAND_RATE, to_number(null) AS OLD_DEMAND_QUANTITY, to_number(null) AS ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity, sup.qty_scrapped AS QTY_SCRAPPED,sup.expected_scrap_qty AS EXPECTED_SCRAP_QTY, sup.qty_completed AS QTY_COMPLETED, SUP.BASE_PLAN_ID, 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.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 as WORK_ORDER_SUB_TYPE, sup.firm_start_quantity as FIRM_START_QUANTITY1, sup.global_attribute_number11 as GLOBAL_ATTR_NUMBER11S, sup.global_attribute_number12 as GLOBAL_ATTR_NUMBER12S, sup.global_attribute_number13 as GLOBAL_ATTR_NUMBER13S, sup.global_attribute_number14 as GLOBAL_ATTR_NUMBER14S, sup.global_attribute_number15 as GLOBAL_ATTR_NUMBER15S, sup.global_attribute_number16 as GLOBAL_ATTR_NUMBER16S, sup.global_attribute_number17 as GLOBAL_ATTR_NUMBER17S, sup.global_attribute_number18 as GLOBAL_ATTR_NUMBER18S, sup.global_attribute_number19 as GLOBAL_ATTR_NUMBER19S, sup.global_attribute_number20 as GLOBAL_ATTR_NUMBER20S, sup.global_attribute_number21 as GLOBAL_ATTR_NUMBER21S, sup.global_attribute_number22 as GLOBAL_ATTR_NUMBER22S, sup.global_attribute_number23 as GLOBAL_ATTR_NUMBER23S, sup.global_attribute_number24 as GLOBAL_ATTR_NUMBER24S, sup.global_attribute_number25 as GLOBAL_ATTR_NUMBER25S, sup.global_attribute_number26 as GLOBAL_ATTR_NUMBER26S, sup.global_attribute_number27 as GLOBAL_ATTR_NUMBER27S, sup.global_attribute_number28 as GLOBAL_ATTR_NUMBER28S, sup.global_attribute_number29 as GLOBAL_ATTR_NUMBER29S, sup.global_attribute_number30 as GLOBAL_ATTR_NUMBER30S, sup.global_attribute_number31 as GLOBAL_ATTR_NUMBER31S, sup.global_attribute_number32 as GLOBAL_ATTR_NUMBER32S, sup.global_attribute_number33 as GLOBAL_ATTR_NUMBER33S, sup.global_attribute_number34 as GLOBAL_ATTR_NUMBER34S, sup.global_attribute_number35 as GLOBAL_ATTR_NUMBER35S, sup.global_attribute_number36 as GLOBAL_ATTR_NUMBER36S, sup.global_attribute_number37 as GLOBAL_ATTR_NUMBER37S, sup.global_attribute_number38 as GLOBAL_ATTR_NUMBER38S, sup.global_attribute_number39 as GLOBAL_ATTR_NUMBER39S, sup.global_attribute_number40 as GLOBAL_ATTR_NUMBER40S, sup.GLOBAL_ATTRIBUTE_CHAR21 as GLOBAL_ATTRIBUTE_CHAR21S, sup.GLOBAL_ATTRIBUTE_CHAR22 as GLOBAL_ATTRIBUTE_CHAR22S, sup.GLOBAL_ATTRIBUTE_CHAR23 as GLOBAL_ATTRIBUTE_CHAR23S, 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, sup.quantity_issued AS ISSUED_QUANTITY, to_number(null) AS CONFIGURED_ITEM, to_char(null) AS CONFIGURED_ITEM_NAME, sup.asset_number, msc_get_name.customer(sup.drop_ship_cust_id) as drop_ship_customer, msc_get_name.customer_site(sup.drop_ship_cust_site_id) as drop_ship_customer_site, sup.receipt_num as receipt_number, sup.revision, sup.delivery_price, sup.schedule_line_num as schedule_line_number, sup.shipment_line_num as shipment_line_number, sup.shipment_header_num as shipment_header_number, sup.source_subinventory_code, to_number(null) AS ALLOW_SPLITS, to_number(null) AS ALLOW_SUBSTITUTION, to_number(null) AS COMPLETED_QUANTITY, null as CUSTOMER_PO_LINE_NUMBER, null as CUSTOMER_PO_SCHEDULE_NUMBER, to_number(null) AS DELIVERY_COST, to_number(null) AS DELIVERY_LEAD_TIME, to_date(NULL) AS EARLIEST_ACCEPT_ARRIVAL_DATE, to_date(NULL) AS EARLIEST_ACCEPT_SHIP_DATE, to_number(null) AS FULFILLMENT_COST, null AS GOP_REFERENCE_ID, to_number(null) AS Included_Items_Indicator, to_number(null) AS INQUIRY_DEMAND, null as ITEM_SUB_TYPE_CODE, null as ITEM_TYPE_CODE, to_date(NULL) as LATEST_ACCEPTABLE_ARRIVAL_DATE, to_date(NULL) as LATEST_ACCEPTABLE_SHIP_DATE, to_number(null) AS Minimum_Percentage_For_Split, to_number(null) AS Minimum_Quantity_For_Split, to_number(null) AS Minimum_Remaining_Shelf_Life, to_number(null) AS ORDER_MARGIN, null as PARENT_FULFILLMENT_LINE, null as PROMISING_SYSTEM, null as ROOT_FULFILLMENT_LINE, null as Sales_Representative_Contact, null as SHIPPING_PREFERENCE, to_number(null) AS SUPPLIER_SITE_SOURCE_SYSTEM, sup.HOLD_DATE AS HOLD_DATE1, msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) as implement_location_code, MscOrderUpdateEO.MATURITY_DATE as MATURITY_DATE, sup.MATURITY_DATE as MATURITY_DATE1 FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_SUPPLIES SUP left outer join (SELECT NVL(mp1.plan_id, -1) as plan_id, pe1.routing_sequence_id, pe1.bill_sequence_id , pe1.process_Sequence_id FROM msc_process_effectivity pe1 left outer join msc_plan_definitions mp1 on pe1.plan_id = NVL(decode(mp1.compile_designator, 'SimPlan', mp1.plan_id, mp1.base_plan_id),mp1.plan_id) ) pe on (sup.plan_id=pe.plan_id and sup.process_seq_id=pe.process_sequence_id) WHERE ( SUP.plan_id = -1 AND MscOrderUpdateEO.TRANSACTION_ID = SUP.TRANSACTION_ID AND MscOrderUpdateEO.SOURCE_TABLE = 'MSC_SUPPLIES' AND MscOrderUpdateEO.new_record=2 ) UNION ALL SELECT /*+ORDERED */ null as CONTRIBUTES_DMD_LATENESS, null as SHARED_SUPPLY, null as CONTRIBUTES_OVERLOAD, null as CONSUMPTION_START_DATE, null as USES_ORDER_MODIFIER, null as LATEST_START_DATE, null as PEGGED_TO_FIRM, null as EARLIEST_START_DATE, MscOrderUpdateEO.CREATED_BY, MscOrderUpdateEO.CREATION_DATE, MscOrderUpdateEO.FIRM_DATE, MscOrderUpdateEO.FIRM_QUANTITY, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER11, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER12, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER13, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER14, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER15, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER16, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER17, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER18, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER19, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER20, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER23, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER24, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER25, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER26, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER27, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER28, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER29, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER30, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER31, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER32, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER33, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER34, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER35, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER36, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER37, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER38, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER39, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER40, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR23, MscOrderUpdateEO.LAST_UPDATE_DATE, MscOrderUpdateEO.LAST_UPDATE_LOGIN, MscOrderUpdateEO.LAST_UPDATED_BY, MscOrderUpdateEO.OBJECT_VERSION_NUMBER, MscOrderUpdateEO.SIMULATION_SET_ID, MscOrderUpdateEO.SOURCE_TABLE, MscOrderUpdateEO.TRANSACTION_ID, MscOrderUpdateEO.NEW_RECORD, MscOrderUpdateEO.DOCUMENT_ID, MscOrderUpdateEO.DOCUMENT_TYPE, MscOrderUpdateEO.SIM_PLAN_ID, MscOrderUpdateEO.SIMULATION_SET_ID as SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, to_date(NULL) AS ACTUAL_START_DATE, NULL AS ALTERNATE_BOM_DESIGNATOR, NULL AS ALTERNATE_ROUTING_DESIGNATOR, dem.APPLIED, dem.arrival_set_id, dem.arrival_set_name, to_number(NULL) AS BILL_SEQUENCE_ID, 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 BUILD_SEQUENCE, NULL AS BUYER_NAME, NULL AS COMMENTS, dem.CREATED_BY AS CREATED_BY1, dem.CREATION_DATE AS CREATION_DATE1, dem.customer_id, dem.customer_site_id, msc_get_name.customer_site( dem.customer_site_id) CUSTOMER_SITE_NAME, dem.demand_class, DECODE(dem.plan_id,-1, dem.order_priority, dem.demand_priority) DEMAND_PRIORITY, dem.override_demand_priority, msc_get_name.designator(dem.schedule_designator_id) as DESIGNATOR_NAME, to_number(NULL) AS DEST_INST_ID, NULL AS DEST_ORG_CODE, to_number(NULL) AS DEST_ORG_ID, dem.DISPOSITION_ID, TO_NUMBER(NULL) as DISPOSITION_STATUS_TYPE, dem.DMD_SATISFIED_DATE, dem.EXPIRATION_DATE, dem.FIRM_DATE AS FIRM_DATE1, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) AS FIRM_PLANNED_TYPE1, dem.FIRM_QUANTITY AS FIRM_QUANTITY1, NULL AS IMPLEMENT_ALTERNATE_BOM, NULL AS IMPLEMENT_ALTERNATE_ROUTING, dem.IMPLEMENT_ARRIVAL_DATE, TO_NUMBER(NULL) AS IMPLEMENT_AS, NULL AS IMPLEMENT_AS_TEXT, to_number(NULL) AS IMPLEMENT_BUILD_SEQUENCE, dem.IMPLEMENT_DATE, NULL AS IMPLEMENT_DEMAND_CLASS, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, to_date(NULL) AS IMPLEMENT_DOCK_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, to_number(NULL) AS IMPLEMENT_EMPLOYEE_ID, dem.IMPLEMENT_FIRM, NULL AS IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, TO_NUMBER(NULL) AS IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, to_number(NULL) AS IMPLEMENT_PROJECT_ID, TO_NUMBER(NULL) AS IMPLEMENT_QUANTITY_RATE, to_number(NULL) AS IMPLEMENT_SCHEDULE_GROUP_ID, dem.IMPLEMENT_SHIP_DATE, NULL AS IMPLEMENT_SHIP_METHOD, dem.implement_org_id AS IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id AS IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) AS IMPLEMENT_STATUS_CODE, to_number(NULL) AS IMPLEMENT_TASK_ID, NULL AS IMPLEMENT_UNIT_NUMBER, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_SITE_ID, TO_CHAR(NULL) AS IMPLEMENT_WIP_CLASS_CODE, TO_NUMBER(NULL) AS IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) AS IN_SOURCE_PLAN, NULL AS INTRANSIT_CALENDAR, dem.INTRANSIT_LEAD_TIME, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) AS ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, dem.USING_ASSEMBLY_DEMAND_DATE AS NEW_DUE_DATE, 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, msc_get_name.customer(dem.customer_id) CUSTOMER_NAME, NVL(dem.RELEASE_STATUS,-1) AS RELEASE_STATUS, dem.planned_ship_date AS SHIP_DATE, TO_DATE(NULL) AS LAST_UNIT_COMPLETION_DATE, dem.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1, dem.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN1, dem.LAST_UPDATED_BY AS LAST_UPDATED_BY1, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL) as latest_acceptable_date, TO_NUMBER(NULL) AS LINE_ID, dem.LOAD_TYPE, NULL AS LOTS_EXIST, to_date(NULL) AS NEED_BY_DATE, TO_DATE(NULL) AS NEW_DOCK_DATE, TO_DATE(NULL) AS NEW_ORDER_DATE, TO_DATE(NULL) AS NEW_START_DATE, to_date(NULL) AS OLD_DOCK_DATE, dem.OLD_DEMAND_DATE AS OLD_DUE_DATE, to_date(NULL) AS OLD_NEED_BY_DATE, dem.OLD_DEMAND_QUANTITY AS OLD_ORDER_QUANTITY, 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.origination_type as ORDER_TYPE, dem.ORGANIZATION_ID, dem.original_inst_id, 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, to_date(NULL) as ORIGINAL_NEED_BY_DATE, dem.original_org_id, 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 PLAN_CUTOFF_DATE, dem.PLAN_ID, to_number(NULL) AS PLAN_INSTANCE_ID, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_date(NULL) AS PLAN_START_DATE, dem.PLANNED_ARRIVAL_DATE AS PLANNED_ARRIVAL_DATE, dem.probability, to_number(NULL) AS PROCESS_SEQ_ID, dem.PROJECT_ID, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) AS PROMISE_DATE, dem.promise_ship_date, dem.quantity_by_due_date*NVL(dem.probability, 1) AS QTY_BY_DUE_DATE, -dem.using_requirement_quantity AS QUANTITY, TO_NUMBER(NULL) AS QUANTITY_IN_PROCESS, -NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) AS QUANTITY_RATE, NULL AS RECEIVING_CALENDAR, dem.RECORD_SOURCE, dem.RELEASE_ERRORS, NULL AS REPETITIVE_TYPE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) AS REQUEST_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, to_date(NULL) AS REQUESTED_COMPLETION_DATE, to_number(NULL) AS RESCHEDULE_DAYS, dem.RESCHEDULE_FLAG AS RESCHEDULED_FLAG, dem.reserved_quantity, to_number(NULL) AS ROUTING_SEQUENCE_ID, dem.ROWID AS ROW_ID, dem.sales_order_line_id, dem.SCHEDULE_ARRIVAL_DATE, to_number(NULL) AS SCHEDULE_COMPRESSION_DAYS, dem.SCHEDULE_DESIGNATOR_ID, to_number(NULL) AS SCHEDULE_GROUP_ID, NULL AS SCHEDULE_GROUP_NAME, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) AS SCHEDULE_SHIP_DATE, dem.selling_price, dem.SHIP_CALENDAR, dem.SHIP_METHOD, 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.ship_set_id, dem.ship_set_name, dem.ship_to_site_id, msc_get_name.customer_site(dem.ship_to_site_id) AS SHIP_TO_SITE_NAME, to_number(NULL) AS SHIPMENT_ID, DECODE(dem.origination_type, 1006, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1007, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1008, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1029, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1030, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), to_number(NULL)) AS SOURCE_DMD_PRIORITY, 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)), 1001, msc_get_name.org_code(dem.source_organization_id), msc_get_name.org_code( dem.source_organization_id)), NULL ) AS SOURCE_ORGANIZATION_CODE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id AS SOURCE_SR_INSTANCE_ID, 'MSC_DEMANDS' AS SOURCE_TABLE2, 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, TO_NUMBER(NULL) AS STATUS_CODE, dem.sub_inventory_code AS SUBINVENTORY_CODE, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, to_date(NULL) AS SUGGESTED_PICK_DATE, NULL AS SUPPLIER_NAME, NULL AS SUPPLIER_SITE_CODE, dem.TASK_ID, dem.DEMAND_ID AS TRANSACTION_ID1, dem.UNIT_NUMBER, dem.unmet_quantity, dem.USING_ASSEMBLY_ITEM_ID, msc_get_name.item_name(dem.using_assembly_item_id, NULL, NULL) AS USING_ASSEMBLY_SEGMENTS, dem.supplier_id AS VENDOR_ID, dem.supplier_site_id AS VENDOR_SITE_ID, to_number(NULL) AS START_QUANTITY, to_number(NULL) AS WIP_STATUS_CODE, NULL AS WIP_STATUS_TEXT, dem.days_late AS LATE_DAYS, to_number(NULL) AS CTB_COMP_AVAIL_PERCENT, to_date(NULL) AS CTB_EXPECTED_DATE, TO_CHAR(NULL) AS CTB_FLAG, to_number(NULL) AS CTB_PRIORITY, to_date(NULL) AS FIRM_START_DATE, to_number(NULL) AS RTB_ORDER_QTY_PERCENT, dem.revised_dmd_date, dem.revised_dmd_priority, dem.ORIG_FIRM_DATE, dem.ORIG_FIRM_QUANTITY, DECODE(dem.zone_id, NULL, NULL, msc_get_name.get_zone_name(dem.zone_id)) AS ZONE, 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), dem.ORCH_ORDER_LINE_NUMBER) as ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, NULL AS BMT_FLAG, NULL AS DROP_SHIP_DEST_TYPE, msc_get_name.msc_sr_lookup_meaning(dem.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, to_number(null) AS NET_SUPPLY_QTY_OVERRIDE, dem.lot_number AS LOT_NUMBER, 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, 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, dem.INVENTORY_ITEM_ID, to_number(NULL) AS new_order_quantity, to_number(NULL) AS SOURCE_SUPPLIER_ID, NULL AS PURCH_LINE_NUM, NULL AS TO_LINE_NUMBER, NULL AS TO_LINE_ID, dem.WIP_ENTITY_NAME, dem.PO_LINE_LOCATION_ID, to_number(NULL) pe_plan_id, to_number(NULL) as pe_routing_sequence_id, to_number(NULL) as pe_bill_sequence_id, dem.ORG_FIRM_FLAG, dem.using_requirement_quantity, dem.DAILY_DEMAND_RATE, dem.OLD_DEMAND_QUANTITY, dem.ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity, null AS QTY_SCRAPPED, null as EXPECTED_SCRAP_QTY, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) as QTY_COMPLETED, DEM.BASE_PLAN_ID, 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, 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, NULL as total_output_quantity, NULL as last_op_completion_date, NULL as work_method_code, NULL as process_name, NULL as BATCH_UOM, to_number(NULL) as WORK_ORDER_SUB_TYPE, to_number(NULL) as FIRM_START_QUANTITY1, dem.global_attribute_number11 as GLOBAL_ATTR_NUMBER11S, dem.global_attribute_number12 as GLOBAL_ATTR_NUMBER12S, dem.global_attribute_number13 as GLOBAL_ATTR_NUMBER13S, dem.global_attribute_number14 as GLOBAL_ATTR_NUMBER14S, dem.global_attribute_number15 as GLOBAL_ATTR_NUMBER15S, dem.global_attribute_number16 as GLOBAL_ATTR_NUMBER16S, dem.global_attribute_number17 as GLOBAL_ATTR_NUMBER17S, dem.global_attribute_number18 as GLOBAL_ATTR_NUMBER18S, dem.global_attribute_number19 as GLOBAL_ATTR_NUMBER19S, dem.global_attribute_number20 as GLOBAL_ATTR_NUMBER20S, dem.global_attribute_number21 as GLOBAL_ATTR_NUMBER21S, dem.global_attribute_number22 as GLOBAL_ATTR_NUMBER22S, dem.global_attribute_number23 as GLOBAL_ATTR_NUMBER23S, dem.global_attribute_number24 as GLOBAL_ATTR_NUMBER24S, dem.global_attribute_number25 as GLOBAL_ATTR_NUMBER25S, dem.global_attribute_number26 as GLOBAL_ATTR_NUMBER26S, dem.global_attribute_number27 as GLOBAL_ATTR_NUMBER27S, dem.global_attribute_number28 as GLOBAL_ATTR_NUMBER28S, dem.global_attribute_number29 as GLOBAL_ATTR_NUMBER29S, dem.global_attribute_number30 as GLOBAL_ATTR_NUMBER30S, dem.global_attribute_number31 as GLOBAL_ATTR_NUMBER31S, dem.global_attribute_number32 as GLOBAL_ATTR_NUMBER32S, dem.global_attribute_number33 as GLOBAL_ATTR_NUMBER33S, dem.global_attribute_number34 as GLOBAL_ATTR_NUMBER34S, dem.global_attribute_number35 as GLOBAL_ATTR_NUMBER35S, dem.global_attribute_number36 as GLOBAL_ATTR_NUMBER36S, dem.global_attribute_number37 as GLOBAL_ATTR_NUMBER37S, dem.global_attribute_number38 as GLOBAL_ATTR_NUMBER38S, dem.global_attribute_number39 as GLOBAL_ATTR_NUMBER39S, dem.global_attribute_number40 as GLOBAL_ATTR_NUMBER40S, dem.GLOBAL_ATTRIBUTE_CHAR21 as GLOBAL_ATTRIBUTE_CHAR21S, dem.GLOBAL_ATTRIBUTE_CHAR22 as GLOBAL_ATTRIBUTE_CHAR22S, dem.GLOBAL_ATTRIBUTE_CHAR23 as GLOBAL_ATTRIBUTE_CHAR23S, 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, 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, null as drop_ship_customer, null as drop_ship_customer_site, null as receipt_number, null as revision, to_number(null) as delivery_price, to_char(null) as schedule_line_number, null as shipment_line_number, null as shipment_header_number, null as source_subinventory_code, DEM.ALLOW_SPLITS, DEM.ALLOW_SUBSTITUTION, DEM.COMPLETED_QUANTITY, DEM.CUSTOMER_PO_LINE_NUMBER, DEM.CUSTOMER_PO_SCHEDULE_NUMBER, DEM.DELIVERY_COST, DEM.DELIVERY_LEAD_TIME, DEM.EARLIEST_ACCEPT_ARRIVAL_DATE, DEM.EARLIEST_ACCEPT_SHIP_DATE, DEM.FULFILLMENT_COST, DEM.GOP_REFERENCE_ID, DEM.INCLUDED_ITEMS_FLAG as Included_Items_Indicator, DEM.INQUIRY_DEMAND, DEM.ITEM_SUB_TYPE_CODE, DEM.ITEM_TYPE_CODE, DEM.LATEST_ACCEPTABLE_ARRIVAL_DATE, DEM.LATEST_ACCEPTABLE_SHIP_DATE, DEM.MIN_PERCENTAGE_FOR_SPLIT as Minimum_Percentage_For_Split, DEM.MIN_QUANTITY_FOR_SPLIT as Minimum_Quantity_For_Split, DEM.MIN_REM_SHELF_LIFE_DAYS as Minimum_Remaining_Shelf_Life, DEM.ORDER_MARGIN, DEM.PARENT_FULFILLMENT_LINE, DEM.PROMISING_SYSTEM, DEM.ROOT_FULFILLMENT_LINE, DEM.SALESREP_CONTACT as Sales_Representative_Contact, DEM.SHIPPING_PREFERENCE, DEM.SUPPLIER_SITE_SOURCE_SYSTEM_ID as SUPPLIER_SITE_SOURCE_SYSTEM, to_date(null) AS HOLD_DATE1, to_char(null) as implement_location_code, to_date(null) as MATURITY_DATE, to_date(null) as MATURITY_DATE1 FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_DEMANDS dem WHERE ( MscOrderUpdateEO.sim_plan_id= dem.plan_id AND MscOrderUpdateEO.TRANSACTION_ID = dem.DEMAND_ID AND MscOrderUpdateEO.SOURCE_TABLE = 'MSC_DEMANDS' AND MscOrderUpdateEO.new_record=1 ) union all SELECT /*+ORDERED */ null as CONTRIBUTES_DMD_LATENESS, null as SHARED_SUPPLY, null as CONTRIBUTES_OVERLOAD, null as CONSUMPTION_START_DATE, null as USES_ORDER_MODIFIER, null as LATEST_START_DATE, null as PEGGED_TO_FIRM, null as EARLIEST_START_DATE, MscOrderUpdateEO.CREATED_BY, MscOrderUpdateEO.CREATION_DATE, MscOrderUpdateEO.FIRM_DATE, MscOrderUpdateEO.FIRM_QUANTITY, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER11, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER12, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER13, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER14, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER15, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER16, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER17, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER18, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER19, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER20, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER23, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER24, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER25, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER26, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER27, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER28, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER29, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER30, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER31, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER32, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER33, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER34, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER35, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER36, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER37, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER38, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER39, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_NUMBER40, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR21, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR22, MscOrderUpdateEO.GLOBAL_ATTRIBUTE_CHAR23, MscOrderUpdateEO.LAST_UPDATE_DATE, MscOrderUpdateEO.LAST_UPDATE_LOGIN, MscOrderUpdateEO.LAST_UPDATED_BY, MscOrderUpdateEO.OBJECT_VERSION_NUMBER, MscOrderUpdateEO.SIMULATION_SET_ID, MscOrderUpdateEO.SOURCE_TABLE, MscOrderUpdateEO.TRANSACTION_ID, MscOrderUpdateEO.NEW_RECORD, MscOrderUpdateEO.DOCUMENT_ID, MscOrderUpdateEO.DOCUMENT_TYPE, MscOrderUpdateEO.SIM_PLAN_ID, MscOrderUpdateEO.SIMULATION_SET_ID as SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, to_date(NULL) AS ACTUAL_START_DATE, NULL AS ALTERNATE_BOM_DESIGNATOR, NULL AS ALTERNATE_ROUTING_DESIGNATOR, dem.APPLIED, dem.arrival_set_id, dem.arrival_set_name, to_number(NULL) AS BILL_SEQUENCE_ID, 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 BUILD_SEQUENCE, NULL AS BUYER_NAME, NULL AS COMMENTS, dem.CREATED_BY AS CREATED_BY1, dem.CREATION_DATE AS CREATION_DATE1, dem.customer_id, dem.customer_site_id, msc_get_name.customer_site( dem.customer_site_id) CUSTOMER_SITE_NAME, dem.demand_class, DECODE(dem.plan_id,-1, dem.order_priority, dem.demand_priority) DEMAND_PRIORITY, dem.override_demand_priority, msc_get_name.designator(dem.schedule_designator_id) as DESIGNATOR_NAME, to_number(NULL) AS DEST_INST_ID, NULL AS DEST_ORG_CODE, to_number(NULL) AS DEST_ORG_ID, dem.DISPOSITION_ID, TO_NUMBER(NULL) as DISPOSITION_STATUS_TYPE, dem.DMD_SATISFIED_DATE, dem.EXPIRATION_DATE, dem.FIRM_DATE AS FIRM_DATE1, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) AS FIRM_PLANNED_TYPE1, dem.FIRM_QUANTITY AS FIRM_QUANTITY1, NULL AS IMPLEMENT_ALTERNATE_BOM, NULL AS IMPLEMENT_ALTERNATE_ROUTING, dem.IMPLEMENT_ARRIVAL_DATE, TO_NUMBER(NULL) AS IMPLEMENT_AS, NULL AS IMPLEMENT_AS_TEXT, to_number(NULL) AS IMPLEMENT_BUILD_SEQUENCE, dem.IMPLEMENT_DATE, NULL AS IMPLEMENT_DEMAND_CLASS, to_number(NULL) AS IMPLEMENT_DEST_INST_ID, NULL AS IMPLEMENT_DEST_ORG_CODE, to_number(NULL) AS IMPLEMENT_DEST_ORG_ID, to_date(NULL) AS IMPLEMENT_DOCK_DATE, to_date(NULL) AS IMPLEMENT_DUE_DATE, to_number(NULL) AS IMPLEMENT_EMPLOYEE_ID, dem.IMPLEMENT_FIRM, NULL AS IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) AS IMPLEMENT_LINE_ID, TO_NUMBER(NULL) AS IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) AS IMPLEMENT_PROCESSING_DAYS, to_number(NULL) AS IMPLEMENT_PROJECT_ID, TO_NUMBER(NULL) AS IMPLEMENT_QUANTITY_RATE, to_number(NULL) AS IMPLEMENT_SCHEDULE_GROUP_ID, dem.IMPLEMENT_SHIP_DATE, NULL AS IMPLEMENT_SHIP_METHOD, dem.implement_org_id AS IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id AS IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) AS IMPLEMENT_STATUS_CODE, to_number(NULL) AS IMPLEMENT_TASK_ID, NULL AS IMPLEMENT_UNIT_NUMBER, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) AS IMPLEMENT_VENDOR_SITE_ID, TO_CHAR(NULL) AS IMPLEMENT_WIP_CLASS_CODE, TO_NUMBER(NULL) AS IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) AS IN_SOURCE_PLAN, NULL AS INTRANSIT_CALENDAR, dem.INTRANSIT_LEAD_TIME, msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) AS ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, dem.USING_ASSEMBLY_DEMAND_DATE AS NEW_DUE_DATE, 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, msc_get_name.customer(dem.customer_id) CUSTOMER_NAME, NVL(dem.RELEASE_STATUS,-1) AS RELEASE_STATUS, dem.planned_ship_date AS SHIP_DATE, TO_DATE(NULL) AS LAST_UNIT_COMPLETION_DATE, dem.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1, dem.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN1, dem.LAST_UPDATED_BY AS LAST_UPDATED_BY1, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL) as latest_acceptable_date, TO_NUMBER(NULL) AS LINE_ID, dem.LOAD_TYPE, NULL AS LOTS_EXIST, to_date(NULL) AS NEED_BY_DATE, TO_DATE(NULL) AS NEW_DOCK_DATE, TO_DATE(NULL) AS NEW_ORDER_DATE, TO_DATE(NULL) AS NEW_START_DATE, to_date(NULL) AS OLD_DOCK_DATE, dem.OLD_DEMAND_DATE AS OLD_DUE_DATE, to_date(NULL) AS OLD_NEED_BY_DATE, dem.OLD_DEMAND_QUANTITY AS OLD_ORDER_QUANTITY, 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.origination_type as ORDER_TYPE, dem.ORGANIZATION_ID, dem.original_inst_id, 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, to_date(NULL) as ORIGINAL_NEED_BY_DATE, dem.original_org_id, dem.using_requirement_quantity+nvl(dem.completed_quantity,0) AS ORIGINAL_QUANTITY, to_date(NULL) AS PLAN_CUTOFF_DATE, dem.PLAN_ID, to_number(NULL) AS PLAN_INSTANCE_ID, to_number(NULL) AS PLAN_ORGANIZATION_ID, to_date(NULL) AS PLAN_START_DATE, dem.PLANNED_ARRIVAL_DATE AS PLANNED_ARRIVAL_DATE, dem.probability, to_number(NULL) AS PROCESS_SEQ_ID, dem.PROJECT_ID, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) AS PROMISE_DATE, dem.promise_ship_date, dem.quantity_by_due_date*NVL(dem.probability, 1) AS QTY_BY_DUE_DATE, -dem.using_requirement_quantity AS QUANTITY, TO_NUMBER(NULL) AS QUANTITY_IN_PROCESS, -NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) AS QUANTITY_RATE, NULL AS RECEIVING_CALENDAR, dem.RECORD_SOURCE, dem.RELEASE_ERRORS, NULL AS REPETITIVE_TYPE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) AS REQUEST_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, to_date(NULL) AS REQUESTED_COMPLETION_DATE, to_number(NULL) AS RESCHEDULE_DAYS, dem.RESCHEDULE_FLAG AS RESCHEDULED_FLAG, dem.reserved_quantity, to_number(NULL) AS ROUTING_SEQUENCE_ID, dem.ROWID AS ROW_ID, dem.sales_order_line_id, dem.SCHEDULE_ARRIVAL_DATE, to_number(NULL) AS SCHEDULE_COMPRESSION_DAYS, dem.SCHEDULE_DESIGNATOR_ID, to_number(NULL) AS SCHEDULE_GROUP_ID, NULL AS SCHEDULE_GROUP_NAME, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) AS SCHEDULE_SHIP_DATE, dem.selling_price, dem.SHIP_CALENDAR, dem.SHIP_METHOD, 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.ship_set_id, dem.ship_set_name, dem.ship_to_site_id, msc_get_name.customer_site(dem.ship_to_site_id) AS SHIP_TO_SITE_NAME, to_number(NULL) AS SHIPMENT_ID, DECODE(dem.origination_type, 1006, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1007, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1008, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1029, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), 1030, msc_get_name.source_demand_priority( dem.plan_id, dem.demand_id), to_number(NULL)) AS SOURCE_DMD_PRIORITY, 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)), 1001, msc_get_name.org_code(dem.source_organization_id), msc_get_name.org_code( dem.source_organization_id)), NULL ) AS SOURCE_ORGANIZATION_CODE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id AS SOURCE_SR_INSTANCE_ID, 'MSC_DEMANDS' AS SOURCE_TABLE2, 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, TO_NUMBER(NULL) AS STATUS_CODE, dem.sub_inventory_code AS SUBINVENTORY_CODE, to_number(NULL) AS SUBSTITUTE_COMPONENT_RANK, to_date(NULL) AS SUGGESTED_PICK_DATE, NULL AS SUPPLIER_NAME, NULL AS SUPPLIER_SITE_CODE, dem.TASK_ID, dem.DEMAND_ID AS TRANSACTION_ID1, dem.UNIT_NUMBER, dem.unmet_quantity, dem.USING_ASSEMBLY_ITEM_ID, msc_get_name.item_name(dem.using_assembly_item_id, NULL, NULL) AS USING_ASSEMBLY_SEGMENTS, dem.supplier_id AS VENDOR_ID, dem.supplier_site_id AS VENDOR_SITE_ID, to_number(NULL) AS START_QUANTITY, to_number(NULL) AS WIP_STATUS_CODE, NULL AS WIP_STATUS_TEXT, dem.days_late AS LATE_DAYS, to_number(NULL) AS CTB_COMP_AVAIL_PERCENT, to_date(NULL) AS CTB_EXPECTED_DATE, TO_CHAR(NULL) AS CTB_FLAG, to_number(NULL) AS CTB_PRIORITY, to_date(NULL) AS FIRM_START_DATE, to_number(NULL) AS RTB_ORDER_QTY_PERCENT, dem.revised_dmd_date, dem.revised_dmd_priority, dem.ORIG_FIRM_DATE, dem.ORIG_FIRM_QUANTITY, DECODE(dem.zone_id, NULL, NULL, msc_get_name.get_zone_name(dem.zone_id)) AS ZONE, 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), dem.ORCH_ORDER_LINE_NUMBER) as ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, NULL AS BMT_FLAG, NULL AS DROP_SHIP_DEST_TYPE, msc_get_name.msc_sr_lookup_meaning(dem.demand_class, 'DEMAND_CLASS') AS DEMAND_CLASS_CODE, to_number(null) AS NET_SUPPLY_QTY_OVERRIDE, dem.lot_number AS LOT_NUMBER, 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, 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, dem.INVENTORY_ITEM_ID, to_number(NULL) AS new_order_quantity, to_number(NULL) AS SOURCE_SUPPLIER_ID, NULL AS PURCH_LINE_NUM, NULL AS TO_LINE_NUMBER, NULL AS TO_LINE_ID, dem.WIP_ENTITY_NAME, dem.PO_LINE_LOCATION_ID, to_number(NULL) pe_plan_id, to_number(NULL) as pe_routing_sequence_id, to_number(NULL) as pe_bill_sequence_id, dem.ORG_FIRM_FLAG, dem.using_requirement_quantity, dem.DAILY_DEMAND_RATE, dem.OLD_DEMAND_QUANTITY, dem.ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity, null AS QTY_SCRAPPED, null AS EXPECTED_SCRAP_QTY, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) as QTY_COMPLETED, DEM.BASE_PLAN_ID, 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, 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, NULL as total_output_quantity, NULL as last_op_completion_date, NULL as work_method_code, NULL as process_name, NULL as BATCH_UOM, to_number(NULL) as WORK_ORDER_SUB_TYPE, to_number(NULL) as FIRM_START_QUANTITY1, dem.global_attribute_number11 as GLOBAL_ATTR_NUMBER11S, dem.global_attribute_number12 as GLOBAL_ATTR_NUMBER12S, dem.global_attribute_number13 as GLOBAL_ATTR_NUMBER13S, dem.global_attribute_number14 as GLOBAL_ATTR_NUMBER14S, dem.global_attribute_number15 as GLOBAL_ATTR_NUMBER15S, dem.global_attribute_number16 as GLOBAL_ATTR_NUMBER16S, dem.global_attribute_number17 as GLOBAL_ATTR_NUMBER17S, dem.global_attribute_number18 as GLOBAL_ATTR_NUMBER18S, dem.global_attribute_number19 as GLOBAL_ATTR_NUMBER19S, dem.global_attribute_number20 as GLOBAL_ATTR_NUMBER20S, dem.global_attribute_number21 as GLOBAL_ATTR_NUMBER21S, dem.global_attribute_number22 as GLOBAL_ATTR_NUMBER22S, dem.global_attribute_number23 as GLOBAL_ATTR_NUMBER23S, dem.global_attribute_number24 as GLOBAL_ATTR_NUMBER24S, dem.global_attribute_number25 as GLOBAL_ATTR_NUMBER25S, dem.global_attribute_number26 as GLOBAL_ATTR_NUMBER26S, dem.global_attribute_number27 as GLOBAL_ATTR_NUMBER27S, dem.global_attribute_number28 as GLOBAL_ATTR_NUMBER28S, dem.global_attribute_number29 as GLOBAL_ATTR_NUMBER29S, dem.global_attribute_number30 as GLOBAL_ATTR_NUMBER30S, dem.global_attribute_number31 as GLOBAL_ATTR_NUMBER31S, dem.global_attribute_number32 as GLOBAL_ATTR_NUMBER32S, dem.global_attribute_number33 as GLOBAL_ATTR_NUMBER33S, dem.global_attribute_number34 as GLOBAL_ATTR_NUMBER34S, dem.global_attribute_number35 as GLOBAL_ATTR_NUMBER35S, dem.global_attribute_number36 as GLOBAL_ATTR_NUMBER36S, dem.global_attribute_number37 as GLOBAL_ATTR_NUMBER37S, dem.global_attribute_number38 as GLOBAL_ATTR_NUMBER38S, dem.global_attribute_number39 as GLOBAL_ATTR_NUMBER39S, dem.global_attribute_number40 as GLOBAL_ATTR_NUMBER40S, dem.GLOBAL_ATTRIBUTE_CHAR21 as GLOBAL_ATTRIBUTE_CHAR21S, dem.GLOBAL_ATTRIBUTE_CHAR22 as GLOBAL_ATTRIBUTE_CHAR22S, dem.GLOBAL_ATTRIBUTE_CHAR23 as GLOBAL_ATTRIBUTE_CHAR23S, 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, 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, null as drop_ship_customer, null as drop_ship_customer_site, null as receipt_number, null as revision, to_number(null) as delivery_price, to_char(null) as schedule_line_number, null as shipment_line_number, null as shipment_header_number, null as source_subinventory_code, DEM.ALLOW_SPLITS, DEM.ALLOW_SUBSTITUTION, DEM.COMPLETED_QUANTITY, DEM.CUSTOMER_PO_LINE_NUMBER, DEM.CUSTOMER_PO_SCHEDULE_NUMBER, DEM.DELIVERY_COST, DEM.DELIVERY_LEAD_TIME, DEM.EARLIEST_ACCEPT_ARRIVAL_DATE, DEM.EARLIEST_ACCEPT_SHIP_DATE, DEM.FULFILLMENT_COST, DEM.GOP_REFERENCE_ID, DEM.INCLUDED_ITEMS_FLAG as Included_Items_Indicator, DEM.INQUIRY_DEMAND, DEM.ITEM_SUB_TYPE_CODE, DEM.ITEM_TYPE_CODE, DEM.LATEST_ACCEPTABLE_ARRIVAL_DATE, DEM.LATEST_ACCEPTABLE_SHIP_DATE, DEM.MIN_PERCENTAGE_FOR_SPLIT as Minimum_Percentage_For_Split, DEM.MIN_QUANTITY_FOR_SPLIT as Minimum_Quantity_For_Split, DEM.MIN_REM_SHELF_LIFE_DAYS as Minimum_Remaining_Shelf_Life, DEM.ORDER_MARGIN, DEM.PARENT_FULFILLMENT_LINE, DEM.PROMISING_SYSTEM, DEM.ROOT_FULFILLMENT_LINE, DEM.SALESREP_CONTACT as Sales_Representative_Contact, DEM.SHIPPING_PREFERENCE, DEM.SUPPLIER_SITE_SOURCE_SYSTEM_ID as SUPPLIER_SITE_SOURCE_SYSTEM, to_date(null) AS HOLD_DATE1, to_char(null) as implement_location_code, to_date(null) as MATURITY_DATE, to_date(null) as MATURITY_DATE1 FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_DEMANDS dem WHERE ( dem.plan_id = -1 AND MscOrderUpdateEO.TRANSACTION_ID = dem.DEMAND_ID AND MscOrderUpdateEO.SOURCE_TABLE = 'MSC_DEMANDS' and MscOrderUpdateEO.new_record=2 )