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 CUMULATIVE_YIELD

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 SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, SUP.ACTUAL_START_DATE, SUP.ALTERNATE_BOM_DESIGNATOR, SUP.ALTERNATE_ROUTING_DESIGNATOR, SUP.APPLIED, to_number(NULL) ARRIVAL_SET_ID, NULL ARRIVAL_SET_NAME, SUP.BILL_SEQUENCE_ID, NULL 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)) BUILD_SEQUENCE, NULL BUYER_NAME, msc_get_name.get_order_Comments(sup.plan_id, 'SUPPLY', sup.TRANSACTION_ID) COMMENTS, SUP.CREATED_BY CREATED_BY1, SUP.CREATION_DATE CREATION_DATE1, nvl(sup.drop_ship_cust_id, sup.customer_id) CUSTOMER_ID, nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID) CUSTOMER_SITE_ID, (select msc_get_name.customer_site( nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID)) from dual) CUSTOMER_SITE_NAME, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) DEMAND_CLASS, sup.schedule_priority DEMAND_PRIORITY, NULL OVERRIDE_DEMAND_PRIORITY, sup.schedule_designator DESIGNATOR_NAME, to_number(NULL) DEST_INST_ID, NULL DEST_ORG_CODE, to_number(NULL) DEST_ORG_ID, SUP.DISPOSITION_ID, SUP.DISPOSITION_STATUS_TYPE, to_date(NULL) DMD_SATISFIED_DATE, SUP.EXPIRATION_DATE, SUP.FIRM_DATE FIRM_DATE1, SUP.FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE1, SUP.FIRM_QUANTITY FIRM_QUANTITY1, SUP.IMPLEMENT_ALTERNATE_BOM, SUP.IMPLEMENT_ALTERNATE_ROUTING, to_date(NULL) IMPLEMENT_ARRIVAL_DATE, SUP.IMPLEMENT_AS, DECODE(sup.implement_as, NULL, NULL, (select msc_get_name.lookup_meaning( 'ORA_MSC_WORKBENCH_IMPLEMENT_AS',sup.implement_as) from dual)) IMPLEMENT_AS_TEXT, SUP.IMPLEMENT_BUILD_SEQUENCE, SUP.IMPLEMENT_DATE, SUP.IMPLEMENT_DEMAND_CLASS, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, to_number(NULL) IMPLEMENT_DEST_ORG_ID, SUP.IMPLEMENT_DOCK_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, SUP.IMPLEMENT_EMPLOYEE_ID, SUP.IMPLEMENT_FIRM, SUP.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, SUP.IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, SUP.IMPLEMENT_PROJECT_ID, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) IMPLEMENT_QUANTITY_RATE, SUP.IMPLEMENT_SCHEDULE_GROUP_ID, SUP.IMPLEMENT_SHIP_DATE, SUP.IMPLEMENT_SHIP_METHOD, SUP.IMPLEMENT_SOURCE_ORG_ID, NULL IMPLEMENT_SR_INSTANCE_ID, SUP.IMPLEMENT_STATUS_CODE, SUP.IMPLEMENT_TASK_ID, SUP.IMPLEMENT_UNIT_NUMBER, sup.implement_supplier_id IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id IMPLEMENT_VENDOR_SITE_ID, SUP.IMPLEMENT_WIP_CLASS_CODE, SUP.IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) IN_SOURCE_PLAN, SUP.INTRANSIT_CALENDAR, SUP.INTRANSIT_LEAD_TIME, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) from dual) ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, sup.NEW_SCHEDULE_DATE 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) ORDER_NUMBER, (select msc_get_name.customer(nvl(sup.drop_ship_cust_id, sup.customer_id)) from dual) CUSTOMER_NAME, NVL(sup.RELEASE_STATUS,-1) RELEASE_STATUS, sup.new_ship_date SHIP_DATE, SUP.LAST_UNIT_COMPLETION_DATE, SUP.LAST_UPDATE_DATE LAST_UPDATE_DATE1, SUP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN1, SUP.LAST_UPDATED_BY LAST_UPDATED_BY1, to_date(NULL) LATEST_ACCEPTABLE_DATE, SUP.LINE_ID, SUP.LOAD_TYPE, NULL LOTS_EXIST, SUP.NEED_BY_DATE, SUP.NEW_DOCK_DATE, NVL(sup.NEW_ORDER_PLACEMENT_DATE, sup.firm_date) NEW_ORDER_DATE, sup.NEW_WIP_START_DATE NEW_START_DATE, SUP.OLD_DOCK_DATE, sup.OLD_SCHEDULE_DATE OLD_DUE_DATE, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) OLD_NEED_BY_DATE, SUP.OLD_ORDER_QUANTITY, to_number(NULL) ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) ORDER_DATE_TYPE_TEXT, SUP.ORDER_TYPE, SUP.ORGANIZATION_ID, to_number(NULL) ORIGINAL_INST_ID, to_number(NULL) ORIGINAL_ITEM_ID, NULL ORIGINAL_ITEM_NAME, to_number(NULL) ORIGINAL_ITEM_QTY, SUP.ORIGINAL_NEED_BY_DATE, to_number(NULL) ORIGINAL_ORG_ID, SUP.ORIGINAL_QUANTITY, to_date(NULL) PLAN_CUTOFF_DATE, SUP.PLAN_ID, to_number(NULL) PLAN_INSTANCE_ID, to_number(NULL) PLAN_ORGANIZATION_ID, to_date(NULL) PLAN_START_DATE, to_date(NULL) PLANNED_ARRIVAL_DATE, to_number(NULL) PROBABILITY, SUP.PROCESS_SEQ_ID, SUP.PROJECT_ID, sup.promised_date PROMISE_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) PROMISE_SHIP_DATE, to_number(NULL) QTY_BY_DUE_DATE, sup.new_order_quantity QUANTITY, SUP.QUANTITY_IN_PROCESS, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) QUANTITY_RATE, SUP.RECEIVING_CALENDAR, SUP.RECORD_SOURCE, SUP.RELEASE_ERRORS, NULL REPETITIVE_TYPE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) REQUEST_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) REQUEST_SHIP_DATE, SUP.REQUESTED_COMPLETION_DATE, SUP.RESCHEDULE_DAYS, sup.RESCHEDULE_FLAG RESCHEDULED_FLAG, sup.reserved_quantity, SUP.ROUTING_SEQUENCE_ID, SUP.ROWID ROW_ID, NULL SALES_ORDER_LINE_ID, to_date(NULL) SCHEDULE_ARRIVAL_DATE, sup.schedule_compress_days SCHEDULE_COMPRESSION_DAYS, SUP.SCHEDULE_DESIGNATOR_ID 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)) SCHEDULE_GROUP_ID, SUP.SCHEDULE_GROUP_NAME, to_date(NULL) SCHEDULE_SHIP_DATE, to_number(NULL) 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)) ship_method_text, to_number(NULL) ship_set_id, NULL SHIP_SET_NAME, to_number(NULL) SHIP_TO_SITE_ID, NULL SHIP_TO_SITE_NAME, SUP.SHIPMENT_ID, to_number(NULL) SOURCE_DMD_PRIORITY, decode(sup.source_organization_id, null, null, (select msc_get_name.org_code(sup.source_organization_id) from dual)) SOURCE_ORGANIZATION_CODE, SUP.SOURCE_ORGANIZATION_ID, NULL SOURCE_SR_INSTANCE_ID, 'MSC_SUPPLIES' SOURCE_TABLE2, decode(sup.supplier_id, null, null, (select msc_get_name.supplier(sup.supplier_id) from dual)) SOURCE_VENDOR_NAME, decode(sup.supplier_site_id, null, null, (select msc_get_name.supplier_site(sup.supplier_site_id) from dual)) SOURCE_VENDOR_SITE_CODE, sup.wip_status_code STATUS_CODE, SUP.SUBINVENTORY_CODE, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, to_date(NULL) SUGGESTED_PICK_DATE, NULL SUPPLIER_NAME, NULL SUPPLIER_SITE_CODE, SUP.TASK_ID, sup.TRANSACTION_ID TRANSACTION_ID1, SUP.UNIT_NUMBER, to_number(NULL) UNMET_QUANTITY, to_number(NULL) USING_ASSEMBLY_ITEM_ID, NULL USING_ASSEMBLY_SEGMENTS, sup.supplier_id VENDOR_ID, sup.supplier_site_id VENDOR_SITE_ID, SUP.START_QUANTITY, SUP.WIP_STATUS_CODE, decode(sup.wip_status_code, null, null, (select msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) from dual)) WIP_STATUS_TEXT, SUP.days_late LATE_DAYS, SUP.CTB_COMP_AVAIL_PERCENT, SUP.CTB_EXPECTED_DATE, SUP.CTB_FLAG, sup.CTB_PRIOIRTY CTB_PRIORITY, SUP.FIRM_START_DATE, SUP.RTB_ORDER_QTY_PERCENT, to_date(NULL) REVISED_DMD_DATE, to_number(NULL) REVISED_DMD_PRIORITY, SUP.ORIG_FIRM_DATE, SUP.ORIG_FIRM_QUANTITY, decode(sup.zone_id, null, null, (select msc_get_name.get_zone_name(sup.zone_id) from dual)) ZONE, to_char(null) SO_LINE_NUM, to_char(null) 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) ORCH_ORDER_LINE_NUMBER, to_number(null) FULFILLMENT_LINE_NUM, SUP.BMT_FLAG, SUP.DROP_SHIP_DEST_TYPE, decode(sup.demand_class, null, null, (select msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') from dual)) 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 IMPLEMENT_MODE_OF_TRANSPORT, SUP.IMPLEMENT_SERVICE_LEVEL_ID 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)) IMPLEMENT_SHIP_METHOD_TEXT, to_char(null) CUSTOMER_PO_NUMBER, SUP.DAYS_PAST_DUE, to_number(null) QTY_SATISFIED_BY_RDD, 2 EXPENSE_TRANSFER, to_number(null) PARENT_MODEL_ITEM_ID, to_char(null) 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 pe_plan_id, pe.routing_sequence_id pe_routing_sequence_id, pe.bill_sequence_id pe_bill_sequence_id, to_number(null) ORG_FIRM_FLAG, to_number(null) using_requirement_quantity, to_number(null) DAILY_DEMAND_RATE, to_number(null) OLD_DEMAND_QUANTITY, to_number(null) ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity , sup.qty_scrapped, sup.expected_scrap_qty, sup.qty_completed, SUP.BASE_PLAN_ID, (select msc_get_name.get_timezone_name(SUP.organization_id) from dual) TIMEZONE_NAME, (select msc_get_name.get_timezone_code(SUP.organization_id) from dual) TIMEZONE_CODE, (select msc_get_name.get_source_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_NAME, (select msc_get_name.get_source_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_CODE, (select msc_get_name.get_destination_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_NAME, (select msc_get_name.get_destination_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_CODE, sup.alt_facility_used, sup.alt_supplier_used, sup.alt_work_definition_used, sup.alt_resource_used, sup.substitute_component_used, decode(sup.disposition_status_type, 1,2,2,1,null) CANCELED, sup.total_output_quantity, sup.last_op_completion_date, NVL(sup.WORK_METHOD_CODE, 1) WORK_METHOD_CODE, sup.process_name, decode(sup.uom_code, null, null, (select msc_get_name.get_unit_of_measure(sup.UOM_CODE) from dual)) BATCH_UOM, sup.work_order_sub_type, sup.firm_start_quantity FIRM_START_QUANTITY1, sup.global_attribute_number11 GLOBAL_ATTR_NUMBER11S, sup.global_attribute_number12 GLOBAL_ATTR_NUMBER12S, sup.global_attribute_number13 GLOBAL_ATTR_NUMBER13S, sup.global_attribute_number14 GLOBAL_ATTR_NUMBER14S, sup.global_attribute_number15 GLOBAL_ATTR_NUMBER15S, sup.global_attribute_number16 GLOBAL_ATTR_NUMBER16S, sup.global_attribute_number17 GLOBAL_ATTR_NUMBER17S, sup.global_attribute_number18 GLOBAL_ATTR_NUMBER18S, sup.global_attribute_number19 GLOBAL_ATTR_NUMBER19S, sup.global_attribute_number20 GLOBAL_ATTR_NUMBER20S, sup.global_attribute_number21 GLOBAL_ATTR_NUMBER21S, sup.global_attribute_number22 GLOBAL_ATTR_NUMBER22S, sup.global_attribute_number23 GLOBAL_ATTR_NUMBER23S, sup.global_attribute_number24 GLOBAL_ATTR_NUMBER24S, sup.global_attribute_number25 GLOBAL_ATTR_NUMBER25S, sup.global_attribute_number26 GLOBAL_ATTR_NUMBER26S, sup.global_attribute_number27 GLOBAL_ATTR_NUMBER27S, sup.global_attribute_number28 GLOBAL_ATTR_NUMBER28S, sup.global_attribute_number29 GLOBAL_ATTR_NUMBER29S, sup.global_attribute_number30 GLOBAL_ATTR_NUMBER30S, sup.global_attribute_number31 GLOBAL_ATTR_NUMBER31S, sup.global_attribute_number32 GLOBAL_ATTR_NUMBER32S, sup.global_attribute_number33 GLOBAL_ATTR_NUMBER33S, sup.global_attribute_number34 GLOBAL_ATTR_NUMBER34S, sup.global_attribute_number35 GLOBAL_ATTR_NUMBER35S, sup.global_attribute_number36 GLOBAL_ATTR_NUMBER36S, sup.global_attribute_number37 GLOBAL_ATTR_NUMBER37S, sup.global_attribute_number38 GLOBAL_ATTR_NUMBER38S, sup.global_attribute_number39 GLOBAL_ATTR_NUMBER39S, sup.global_attribute_number40 GLOBAL_ATTR_NUMBER40S, sup.GLOBAL_ATTRIBUTE_CHAR21 GLOBAL_ATTRIBUTE_CHAR21S, sup.GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR22S, sup.GLOBAL_ATTRIBUTE_CHAR23 GLOBAL_ATTRIBUTE_CHAR23S, decode(sup.IMPLEMENT_SOURCE_ORG_ID, null, null, (select msc_get_name.org_code(sup.IMPLEMENT_SOURCE_ORG_ID) from dual)) implement_source_org, decode(sup.IMPLEMENT_SUPPLIER_ID, null, null, (select msc_get_name.supplier(sup.IMPLEMENT_SUPPLIER_ID) from dual)) implement_supplier, decode(sup.IMPLEMENT_SUPPLIER_SITE_ID, null, null, (select msc_get_name.supplier_site(sup.IMPLEMENT_SUPPLIER_SITE_ID) from dual)) implement_supplier_site, to_char(null) ORG_CURRENCY_CODE, nvl(sup.start_quantity,0)-nvl(sup.qty_completed,0)-nvl(sup.qty_scrapped,0) QTY_REMAINING, sup.quantity_issued ISSUED_QUANTITY, to_number(null) CONFIGURED_ITEM, to_char(null) CONFIGURED_ITEM_NAME, sup.asset_number, decode(sup.drop_ship_cust_id, null, null, (select msc_get_name.customer(sup.drop_ship_cust_id) from dual)) drop_ship_customer, decode(sup.drop_ship_cust_site_id, null, null, (select msc_get_name.customer_site(sup.drop_ship_cust_site_id) from dual)) drop_ship_customer_site, sup.receipt_num receipt_number, sup.revision, sup.delivery_price, sup.schedule_line_num schedule_line_number, sup.shipment_line_num shipment_line_number, sup.shipment_header_num shipment_header_number, sup.source_subinventory_code, to_number(null) ALLOW_SPLITS, to_number(null) ALLOW_SUBSTITUTION, to_number(null) COMPLETED_QUANTITY, null CUSTOMER_PO_LINE_NUMBER, null CUSTOMER_PO_SCHEDULE_NUMBER, to_number(null) DELIVERY_COST, to_number(null) DELIVERY_LEAD_TIME, to_date(NULL) EARLIEST_ACCEPT_ARRIVAL_DATE, to_date(NULL) EARLIEST_ACCEPT_SHIP_DATE, to_number(null) FULFILLMENT_COST, null GOP_REFERENCE_ID, to_number(null) Included_Items_Indicator, to_number(null) INQUIRY_DEMAND, null ITEM_SUB_TYPE_CODE, null ITEM_TYPE_CODE, to_date(NULL) LATEST_ACCEPTABLE_ARRIVAL_DATE, to_date(NULL) LATEST_ACCEPTABLE_SHIP_DATE, to_number(null) Minimum_Percentage_For_Split, to_number(null) Minimum_Quantity_For_Split, to_number(null) Minimum_Remaining_Shelf_Life, to_number(null) ORDER_MARGIN, null PARENT_FULFILLMENT_LINE, null PROMISING_SYSTEM, null ROOT_FULFILLMENT_LINE, null Sales_Representative_Contact, null SHIPPING_PREFERENCE, to_number(null) SUPPLIER_SITE_SOURCE_SYSTEM, sup.HOLD_DATE HOLD_DATE1, msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) implement_location_code, MscOrderUpdateEO.MATURITY_DATE MATURITY_DATE, sup.MATURITY_DATE MATURITY_DATE1, sup.CUMULATIVE_YIELD FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_SUPPLIES SUP left outer join (SELECT NVL(mp1.plan_id, -1) 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 SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, SUP.ACTUAL_START_DATE, SUP.ALTERNATE_BOM_DESIGNATOR, SUP.ALTERNATE_ROUTING_DESIGNATOR, SUP.APPLIED, to_number(NULL) ARRIVAL_SET_ID, NULL ARRIVAL_SET_NAME, SUP.BILL_SEQUENCE_ID, NULL 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)) BUILD_SEQUENCE, NULL BUYER_NAME, msc_get_name.get_order_Comments(sup.plan_id, 'SUPPLY', sup.TRANSACTION_ID) COMMENTS, SUP.CREATED_BY CREATED_BY1, SUP.CREATION_DATE CREATION_DATE1, nvl(sup.drop_ship_cust_id, sup.customer_id) CUSTOMER_ID, nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID) CUSTOMER_SITE_ID, (select msc_get_name.customer_site( nvl(sup.drop_ship_cust_site_id, sup.SHIP_TO_SITE_ID)) from dual) CUSTOMER_SITE_NAME, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) DEMAND_CLASS, sup.schedule_priority DEMAND_PRIORITY, NULL OVERRIDE_DEMAND_PRIORITY, sup.schedule_designator DESIGNATOR_NAME, to_number(NULL) DEST_INST_ID, NULL DEST_ORG_CODE, to_number(NULL) DEST_ORG_ID, SUP.DISPOSITION_ID, SUP.DISPOSITION_STATUS_TYPE, to_date(NULL) DMD_SATISFIED_DATE, SUP.EXPIRATION_DATE, SUP.FIRM_DATE FIRM_DATE1, SUP.FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE1, SUP.FIRM_QUANTITY FIRM_QUANTITY1, SUP.IMPLEMENT_ALTERNATE_BOM, SUP.IMPLEMENT_ALTERNATE_ROUTING, to_date(NULL) IMPLEMENT_ARRIVAL_DATE, SUP.IMPLEMENT_AS, DECODE(sup.implement_as, NULL, NULL, (select msc_get_name.lookup_meaning( 'ORA_MSC_WORKBENCH_IMPLEMENT_AS',sup.implement_as) from dual)) IMPLEMENT_AS_TEXT, SUP.IMPLEMENT_BUILD_SEQUENCE, SUP.IMPLEMENT_DATE, SUP.IMPLEMENT_DEMAND_CLASS, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, to_number(NULL) IMPLEMENT_DEST_ORG_ID, SUP.IMPLEMENT_DOCK_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, SUP.IMPLEMENT_EMPLOYEE_ID, SUP.IMPLEMENT_FIRM, SUP.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, SUP.IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, SUP.IMPLEMENT_PROJECT_ID, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) IMPLEMENT_QUANTITY_RATE, SUP.IMPLEMENT_SCHEDULE_GROUP_ID, SUP.IMPLEMENT_SHIP_DATE, SUP.IMPLEMENT_SHIP_METHOD, SUP.IMPLEMENT_SOURCE_ORG_ID, NULL IMPLEMENT_SR_INSTANCE_ID, SUP.IMPLEMENT_STATUS_CODE, SUP.IMPLEMENT_TASK_ID, SUP.IMPLEMENT_UNIT_NUMBER, sup.implement_supplier_id IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id IMPLEMENT_VENDOR_SITE_ID, SUP.IMPLEMENT_WIP_CLASS_CODE, SUP.IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) IN_SOURCE_PLAN, SUP.INTRANSIT_CALENDAR, SUP.INTRANSIT_LEAD_TIME, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) from dual) ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, sup.NEW_SCHEDULE_DATE 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) ORDER_NUMBER, (select msc_get_name.customer(nvl(sup.drop_ship_cust_id, sup.customer_id)) from dual) CUSTOMER_NAME, NVL(sup.RELEASE_STATUS,-1) RELEASE_STATUS, sup.new_ship_date SHIP_DATE, SUP.LAST_UNIT_COMPLETION_DATE, SUP.LAST_UPDATE_DATE LAST_UPDATE_DATE1, SUP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN1, SUP.LAST_UPDATED_BY LAST_UPDATED_BY1, to_date(NULL) LATEST_ACCEPTABLE_DATE, SUP.LINE_ID, SUP.LOAD_TYPE, NULL LOTS_EXIST, SUP.NEED_BY_DATE, SUP.NEW_DOCK_DATE, NVL(sup.NEW_ORDER_PLACEMENT_DATE , sup.firm_date) NEW_ORDER_DATE, sup.NEW_WIP_START_DATE NEW_START_DATE, SUP.OLD_DOCK_DATE, sup.OLD_SCHEDULE_DATE OLD_DUE_DATE, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) OLD_NEED_BY_DATE, SUP.OLD_ORDER_QUANTITY, to_number(NULL) ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) ORDER_DATE_TYPE_TEXT, SUP.ORDER_TYPE, SUP.ORGANIZATION_ID, to_number(NULL) ORIGINAL_INST_ID, to_number(NULL) ORIGINAL_ITEM_ID, NULL ORIGINAL_ITEM_NAME, to_number(NULL) ORIGINAL_ITEM_QTY, SUP.ORIGINAL_NEED_BY_DATE, to_number(NULL) ORIGINAL_ORG_ID, SUP.ORIGINAL_QUANTITY, to_date(NULL) PLAN_CUTOFF_DATE, SUP.PLAN_ID, to_number(NULL) PLAN_INSTANCE_ID, to_number(NULL) PLAN_ORGANIZATION_ID, to_date(NULL) PLAN_START_DATE, to_date(NULL) PLANNED_ARRIVAL_DATE, to_number(NULL) PROBABILITY, SUP.PROCESS_SEQ_ID, SUP.PROJECT_ID, sup.promised_date PROMISE_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) PROMISE_SHIP_DATE, to_number(NULL) QTY_BY_DUE_DATE, sup.new_order_quantity QUANTITY, SUP.QUANTITY_IN_PROCESS, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) QUANTITY_RATE, SUP.RECEIVING_CALENDAR, SUP.RECORD_SOURCE, SUP.RELEASE_ERRORS, NULL REPETITIVE_TYPE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) REQUEST_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) REQUEST_SHIP_DATE, SUP.REQUESTED_COMPLETION_DATE, SUP.RESCHEDULE_DAYS, sup.RESCHEDULE_FLAG RESCHEDULED_FLAG, sup.reserved_quantity, SUP.ROUTING_SEQUENCE_ID, SUP.ROWID ROW_ID, NULL SALES_ORDER_LINE_ID, to_date(NULL) SCHEDULE_ARRIVAL_DATE, sup.schedule_compress_days SCHEDULE_COMPRESSION_DAYS, SUP.SCHEDULE_DESIGNATOR_ID 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)) SCHEDULE_GROUP_ID, SUP.SCHEDULE_GROUP_NAME, to_date(NULL) SCHEDULE_SHIP_DATE, to_number(NULL) 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)) ship_method_text, to_number(NULL) ship_set_id, NULL SHIP_SET_NAME, to_number(NULL) SHIP_TO_SITE_ID, NULL SHIP_TO_SITE_NAME, SUP.SHIPMENT_ID, to_number(NULL) SOURCE_DMD_PRIORITY, decode(sup.source_organization_id, null, null, (select msc_get_name.org_code(sup.source_organization_id) from dual)) SOURCE_ORGANIZATION_CODE, SUP.SOURCE_ORGANIZATION_ID, NULL SOURCE_SR_INSTANCE_ID, 'MSC_SUPPLIES' SOURCE_TABLE2, decode(sup.supplier_id, null, null, (select msc_get_name.supplier(sup.supplier_id) from dual)) SOURCE_VENDOR_NAME, decode(sup.supplier_site_id, null, null, (select msc_get_name.supplier_site(sup.supplier_site_id) from dual)) SOURCE_VENDOR_SITE_CODE, sup.wip_status_code STATUS_CODE, SUP.SUBINVENTORY_CODE, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, to_date(NULL) SUGGESTED_PICK_DATE, NULL SUPPLIER_NAME, NULL SUPPLIER_SITE_CODE, SUP.TASK_ID TASK_ID, sup.TRANSACTION_ID TRANSACTION_ID1, SUP.UNIT_NUMBER, to_number(NULL) UNMET_QUANTITY, to_number(NULL) USING_ASSEMBLY_ITEM_ID, NULL USING_ASSEMBLY_SEGMENTS, sup.supplier_id VENDOR_ID, sup.supplier_site_id VENDOR_SITE_ID, SUP.START_QUANTITY, SUP.WIP_STATUS_CODE, decode(sup.wip_status_code, null, null, (select msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) from dual)) WIP_STATUS_TEXT, SUP.days_late LATE_DAYS, SUP.CTB_COMP_AVAIL_PERCENT, SUP.CTB_EXPECTED_DATE, SUP.CTB_FLAG, sup.CTB_PRIOIRTY CTB_PRIORITY, SUP.FIRM_START_DATE, SUP.RTB_ORDER_QTY_PERCENT, to_date(NULL) REVISED_DMD_DATE, to_number(NULL) REVISED_DMD_PRIORITY, SUP.ORIG_FIRM_DATE, SUP.ORIG_FIRM_QUANTITY, decode(sup.zone_id, null, null, (select msc_get_name.get_zone_name(sup.zone_id) from dual)) ZONE, to_char(null) SO_LINE_NUM, to_char(null) 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) ORCH_ORDER_LINE_NUMBER, to_number(null) FULFILLMENT_LINE_NUM, SUP.BMT_FLAG, SUP.DROP_SHIP_DEST_TYPE, decode(sup.demand_class, null, null, (select msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') from dual)) 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 IMPLEMENT_MODE_OF_TRANSPORT, SUP.IMPLEMENT_SERVICE_LEVEL_ID 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)) IMPLEMENT_SHIP_METHOD_TEXT, to_char(null) CUSTOMER_PO_NUMBER, SUP.DAYS_PAST_DUE, to_number(null) QTY_SATISFIED_BY_RDD, 2 EXPENSE_TRANSFER, to_number(null) PARENT_MODEL_ITEM_ID, to_char(null) 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 pe_plan_id, pe.routing_sequence_id pe_routing_sequence_id, pe.bill_sequence_id pe_bill_sequence_id, to_number(null) ORG_FIRM_FLAG, to_number(null) using_requirement_quantity, to_number(null) DAILY_DEMAND_RATE, to_number(null) OLD_DEMAND_QUANTITY, to_number(null) ORIGINATION_TYPE, MscOrderUpdateEO.firm_start_quantity, sup.qty_scrapped, sup.expected_scrap_qty, sup.qty_completed, SUP.BASE_PLAN_ID, (select msc_get_name.get_timezone_name(SUP.ORGANIZATION_ID) from dual) TIMEZONE_NAME, (select msc_get_name.get_timezone_code(SUP.ORGANIZATION_ID) from dual) TIMEZONE_CODE, (select msc_get_name.get_source_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_NAME, (select msc_get_name.get_source_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_CODE, (select msc_get_name.get_destination_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_NAME, (select msc_get_name.get_destination_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_CODE, sup.alt_facility_used, sup.alt_supplier_used, sup.alt_work_definition_used, sup.alt_resource_used, sup.substitute_component_used, decode(sup.disposition_status_type, 1,2,2,1,null) CANCELED, sup.total_output_quantity, sup.last_op_completion_date, NVL(sup.WORK_METHOD_CODE, 1) WORK_METHOD_CODE, sup.process_name, decode(sup.UOM_CODE, null, null, (select msc_get_name.get_unit_of_measure(sup.UOM_CODE) from dual)) BATCH_UOM, sup.work_order_sub_type, sup.firm_start_quantity FIRM_START_QUANTITY1, sup.global_attribute_number11 GLOBAL_ATTR_NUMBER11S, sup.global_attribute_number12 GLOBAL_ATTR_NUMBER12S, sup.global_attribute_number13 GLOBAL_ATTR_NUMBER13S, sup.global_attribute_number14 GLOBAL_ATTR_NUMBER14S, sup.global_attribute_number15 GLOBAL_ATTR_NUMBER15S, sup.global_attribute_number16 GLOBAL_ATTR_NUMBER16S, sup.global_attribute_number17 GLOBAL_ATTR_NUMBER17S, sup.global_attribute_number18 GLOBAL_ATTR_NUMBER18S, sup.global_attribute_number19 GLOBAL_ATTR_NUMBER19S, sup.global_attribute_number20 GLOBAL_ATTR_NUMBER20S, sup.global_attribute_number21 GLOBAL_ATTR_NUMBER21S, sup.global_attribute_number22 GLOBAL_ATTR_NUMBER22S, sup.global_attribute_number23 GLOBAL_ATTR_NUMBER23S, sup.global_attribute_number24 GLOBAL_ATTR_NUMBER24S, sup.global_attribute_number25 GLOBAL_ATTR_NUMBER25S, sup.global_attribute_number26 GLOBAL_ATTR_NUMBER26S, sup.global_attribute_number27 GLOBAL_ATTR_NUMBER27S, sup.global_attribute_number28 GLOBAL_ATTR_NUMBER28S, sup.global_attribute_number29 GLOBAL_ATTR_NUMBER29S, sup.global_attribute_number30 GLOBAL_ATTR_NUMBER30S, sup.global_attribute_number31 GLOBAL_ATTR_NUMBER31S, sup.global_attribute_number32 GLOBAL_ATTR_NUMBER32S, sup.global_attribute_number33 GLOBAL_ATTR_NUMBER33S, sup.global_attribute_number34 GLOBAL_ATTR_NUMBER34S, sup.global_attribute_number35 GLOBAL_ATTR_NUMBER35S, sup.global_attribute_number36 GLOBAL_ATTR_NUMBER36S, sup.global_attribute_number37 GLOBAL_ATTR_NUMBER37S, sup.global_attribute_number38 GLOBAL_ATTR_NUMBER38S, sup.global_attribute_number39 GLOBAL_ATTR_NUMBER39S, sup.global_attribute_number40 GLOBAL_ATTR_NUMBER40S, sup.GLOBAL_ATTRIBUTE_CHAR21 GLOBAL_ATTRIBUTE_CHAR21S, sup.GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR22S, sup.GLOBAL_ATTRIBUTE_CHAR23 GLOBAL_ATTRIBUTE_CHAR23S, decode(sup.IMPLEMENT_SOURCE_ORG_ID, null, null, (select msc_get_name.org_code(sup.IMPLEMENT_SOURCE_ORG_ID) from dual)) implement_source_org, decode(sup.IMPLEMENT_SUPPLIER_ID, null, null, (select msc_get_name.supplier(sup.IMPLEMENT_SUPPLIER_ID) from dual)) implement_supplier, decode(sup.IMPLEMENT_SUPPLIER_SITE_ID, null, null, (select msc_get_name.supplier_site(sup.IMPLEMENT_SUPPLIER_SITE_ID) from dual)) implement_supplier_site, to_char(null) ORG_CURRENCY_CODE, nvl(sup.start_quantity,0)-nvl(sup.qty_completed,0)-nvl(sup.qty_scrapped,0) QTY_REMAINING, sup.quantity_issued ISSUED_QUANTITY, to_number(null) CONFIGURED_ITEM, to_char(null) CONFIGURED_ITEM_NAME, sup.asset_number, decode(sup.drop_ship_cust_id, null, null, (select msc_get_name.customer(sup.drop_ship_cust_id) from dual)) drop_ship_customer, decode(sup.drop_ship_cust_site_id, null, null, (select msc_get_name.customer_site(sup.drop_ship_cust_site_id) from dual)) drop_ship_customer_site, sup.receipt_num receipt_number, sup.revision, sup.delivery_price, sup.schedule_line_num schedule_line_number, sup.shipment_line_num shipment_line_number, sup.shipment_header_num shipment_header_number, sup.source_subinventory_code, to_number(null) ALLOW_SPLITS, to_number(null) ALLOW_SUBSTITUTION, to_number(null) COMPLETED_QUANTITY, null CUSTOMER_PO_LINE_NUMBER, null CUSTOMER_PO_SCHEDULE_NUMBER, to_number(null) DELIVERY_COST, to_number(null) DELIVERY_LEAD_TIME, to_date(NULL) EARLIEST_ACCEPT_ARRIVAL_DATE, to_date(NULL) EARLIEST_ACCEPT_SHIP_DATE, to_number(null) FULFILLMENT_COST, null GOP_REFERENCE_ID, to_number(null) Included_Items_Indicator, to_number(null) INQUIRY_DEMAND, null ITEM_SUB_TYPE_CODE, null ITEM_TYPE_CODE, to_date(NULL) LATEST_ACCEPTABLE_ARRIVAL_DATE, to_date(NULL) LATEST_ACCEPTABLE_SHIP_DATE, to_number(null) Minimum_Percentage_For_Split, to_number(null) Minimum_Quantity_For_Split, to_number(null) Minimum_Remaining_Shelf_Life, to_number(null) ORDER_MARGIN, null PARENT_FULFILLMENT_LINE, null PROMISING_SYSTEM, null ROOT_FULFILLMENT_LINE, null Sales_Representative_Contact, null SHIPPING_PREFERENCE, to_number(null) SUPPLIER_SITE_SOURCE_SYSTEM, sup.HOLD_DATE HOLD_DATE1, msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) implement_location_code, MscOrderUpdateEO.MATURITY_DATE MATURITY_DATE, sup.MATURITY_DATE MATURITY_DATE1, sup.CUMULATIVE_YIELD FROM fusion.MSC_ORDER_UPDATES MscOrderUpdateEO, fusion.MSC_SUPPLIES SUP left outer join (SELECT NVL(mp1.plan_id, -1) 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 CONTRIBUTES_DMD_LATENESS, null SHARED_SUPPLY, null CONTRIBUTES_OVERLOAD, null CONSUMPTION_START_DATE, null USES_ORDER_MODIFIER, null LATEST_START_DATE, null PEGGED_TO_FIRM, null 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 SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, to_date(NULL) ACTUAL_START_DATE, NULL ALTERNATE_BOM_DESIGNATOR, NULL ALTERNATE_ROUTING_DESIGNATOR, dem.APPLIED, dem.arrival_set_id, dem.arrival_set_name, to_number(NULL) 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((select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG',dem.bucket_type) from dual),null, (select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_GREGORIAN',dem.bucket_type) from dual), (select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG', dem.bucket_type) from dual))) BUCKET_TYPE, to_number(NULL) BUILD_SEQUENCE, NULL BUYER_NAME, NULL COMMENTS, dem.CREATED_BY CREATED_BY1, dem.CREATION_DATE CREATION_DATE1, dem.customer_id, dem.customer_site_id, decode(dem.customer_site_id, null, null, (select msc_get_name.customer_site( dem.customer_site_id) from dual)) CUSTOMER_SITE_NAME, dem.demand_class, DECODE(dem.plan_id,-1, dem.order_priority, dem.demand_priority) DEMAND_PRIORITY, dem.override_demand_priority, (select msc_get_name.designator(dem.schedule_designator_id) from dual) DESIGNATOR_NAME, to_number(NULL) DEST_INST_ID, NULL DEST_ORG_CODE, to_number(NULL) DEST_ORG_ID, dem.DISPOSITION_ID, TO_NUMBER(NULL) DISPOSITION_STATUS_TYPE, dem.DMD_SATISFIED_DATE, dem.EXPIRATION_DATE, dem.FIRM_DATE FIRM_DATE1, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) FIRM_PLANNED_TYPE1, dem.FIRM_QUANTITY FIRM_QUANTITY1, NULL IMPLEMENT_ALTERNATE_BOM, NULL IMPLEMENT_ALTERNATE_ROUTING, dem.IMPLEMENT_ARRIVAL_DATE, TO_NUMBER(NULL) IMPLEMENT_AS, NULL IMPLEMENT_AS_TEXT, to_number(NULL) IMPLEMENT_BUILD_SEQUENCE, dem.IMPLEMENT_DATE, NULL IMPLEMENT_DEMAND_CLASS, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, to_number(NULL) IMPLEMENT_DEST_ORG_ID, to_date(NULL) IMPLEMENT_DOCK_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, to_number(NULL) IMPLEMENT_EMPLOYEE_ID, dem.IMPLEMENT_FIRM, NULL IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, TO_NUMBER(NULL) IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, to_number(NULL) IMPLEMENT_PROJECT_ID, TO_NUMBER(NULL) IMPLEMENT_QUANTITY_RATE, to_number(NULL) IMPLEMENT_SCHEDULE_GROUP_ID, dem.IMPLEMENT_SHIP_DATE, NULL IMPLEMENT_SHIP_METHOD, dem.implement_org_id IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) IMPLEMENT_STATUS_CODE, to_number(NULL) IMPLEMENT_TASK_ID, NULL IMPLEMENT_UNIT_NUMBER, TO_NUMBER(NULL) IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_SITE_ID, TO_CHAR(NULL) IMPLEMENT_WIP_CLASS_CODE, TO_NUMBER(NULL) IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) IN_SOURCE_PLAN, NULL INTRANSIT_CALENDAR, dem.INTRANSIT_LEAD_TIME, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) from dual) ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, dem.USING_ASSEMBLY_DEMAND_DATE 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) ORDER_NUMBER, decode(dem.customer_id, null, null, (select msc_get_name.customer(dem.customer_id) from dual)) CUSTOMER_NAME, NVL(dem.RELEASE_STATUS,-1) RELEASE_STATUS, dem.planned_ship_date SHIP_DATE, TO_DATE(NULL) LAST_UNIT_COMPLETION_DATE, dem.LAST_UPDATE_DATE LAST_UPDATE_DATE1, dem.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN1, dem.LAST_UPDATED_BY LAST_UPDATED_BY1, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL) latest_acceptable_date, TO_NUMBER(NULL) LINE_ID, dem.LOAD_TYPE, NULL LOTS_EXIST, to_date(NULL) NEED_BY_DATE, TO_DATE(NULL) NEW_DOCK_DATE, TO_DATE(NULL) NEW_ORDER_DATE, TO_DATE(NULL) NEW_START_DATE, to_date(NULL) OLD_DOCK_DATE, dem.OLD_DEMAND_DATE OLD_DUE_DATE, to_date(NULL) OLD_NEED_BY_DATE, dem.OLD_DEMAND_QUANTITY OLD_ORDER_QUANTITY, dem.ORDER_DATE_TYPE_CODE, (select msc_get_name.lookup_meaning('ORA_MSC_ORDER_DATE_TYPE_CODE', DECODE(dem.ORDER_DATE_TYPE_CODE, NULL, 1, dem.ORDER_DATE_TYPE_CODE)) from dual) ORDER_DATE_TYPE_TEXT, dem.origination_type ORDER_TYPE, dem.ORGANIZATION_ID, dem.original_inst_id, dem.original_item_id, decode(dem.original_item_id, NULL, NULL, (select msc_get_name.item_name(dem.original_item_id, NULL, NULL) from dual)) ORIGINAL_ITEM_NAME, dem.original_quantity ORIGINAL_ITEM_QTY, to_date(NULL) 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)) ORIGINAL_QUANTITY, to_date(NULL) PLAN_CUTOFF_DATE, dem.PLAN_ID, to_number(NULL) PLAN_INSTANCE_ID, to_number(NULL) PLAN_ORGANIZATION_ID, to_date(NULL) PLAN_START_DATE, dem.PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE, dem.probability, to_number(NULL) PROCESS_SEQ_ID, dem.PROJECT_ID, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) PROMISE_DATE, dem.promise_ship_date, dem.quantity_by_due_date*NVL(dem.probability, 1) QTY_BY_DUE_DATE, -dem.using_requirement_quantity QUANTITY, TO_NUMBER(NULL) QUANTITY_IN_PROCESS, -NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) QUANTITY_RATE, NULL RECEIVING_CALENDAR, dem.RECORD_SOURCE, dem.RELEASE_ERRORS, NULL REPETITIVE_TYPE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) REQUEST_DATE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 1, dem.request_date, null),dem.request_ship_date) REQUEST_SHIP_DATE, to_date(NULL) REQUESTED_COMPLETION_DATE, to_number(NULL) RESCHEDULE_DAYS, dem.RESCHEDULE_FLAG RESCHEDULED_FLAG, dem.reserved_quantity, to_number(NULL) ROUTING_SEQUENCE_ID, dem.ROWID ROW_ID, dem.sales_order_line_id, dem.SCHEDULE_ARRIVAL_DATE, to_number(NULL) SCHEDULE_COMPRESSION_DAYS, dem.SCHEDULE_DESIGNATOR_ID, to_number(NULL) SCHEDULE_GROUP_ID, NULL SCHEDULE_GROUP_NAME, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) 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)) ship_method_text, dem.ship_set_id, dem.ship_set_name, dem.ship_to_site_id, decode(dem.ship_to_site_id, NULL, NULL, (select msc_get_name.customer_site(dem.ship_to_site_id) from dual)) SHIP_TO_SITE_NAME, to_number(NULL) 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)) SOURCE_DMD_PRIORITY, DECODE(dem.supply_id, NULL, DECODE(dem.origination_type, 1006, DECODE( (select msc_get_name.order_type(dem.plan_id, dem.disposition_id) from dual), 2, NULL, (select msc_get_name.org_code(dem.source_organization_id) from dual)), 1030, DECODE( (select msc_get_name.order_type( dem.plan_id, dem.disposition_id) from dual), 2, NULL, (select msc_get_name.org_code(dem.source_organization_id) from dual)), (select msc_get_name.org_code( dem.source_organization_id) from dual)), NULL ) SOURCE_ORGANIZATION_CODE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id SOURCE_SR_INSTANCE_ID, 'MSC_DEMANDS' SOURCE_TABLE2, decode(dem.supplier_id, NULL, NULL, (select msc_get_name.supplier(dem.supplier_id) from dual)) SOURCE_VENDOR_NAME, decode(dem.supplier_site_id, NULL, NULL, (select msc_get_name.supplier_site(dem.supplier_site_id) from dual)) SOURCE_VENDOR_SITE_CODE, TO_NUMBER(NULL) STATUS_CODE, dem.sub_inventory_code SUBINVENTORY_CODE, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, to_date(NULL) SUGGESTED_PICK_DATE, NULL SUPPLIER_NAME, NULL SUPPLIER_SITE_CODE, dem.TASK_ID, dem.DEMAND_ID TRANSACTION_ID1, dem.UNIT_NUMBER, dem.unmet_quantity, dem.USING_ASSEMBLY_ITEM_ID, decode(dem.using_assembly_item_id, -1, NULL, (select msc_get_name.item_name(dem.using_assembly_item_id, NULL, NULL) from dual)) USING_ASSEMBLY_SEGMENTS, dem.supplier_id VENDOR_ID, dem.supplier_site_id VENDOR_SITE_ID, to_number(NULL) START_QUANTITY, to_number(NULL) WIP_STATUS_CODE, NULL WIP_STATUS_TEXT, dem.days_late LATE_DAYS, to_number(NULL) CTB_COMP_AVAIL_PERCENT, to_date(NULL) CTB_EXPECTED_DATE, TO_CHAR(NULL) CTB_FLAG, to_number(NULL) CTB_PRIORITY, to_date(NULL) FIRM_START_DATE, to_number(NULL) 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)) ZONE, dem.SO_LINE_NUM, decode(dem.origination_type, 1030, dem.sales_order_number, dem.ORCH_ORDER_NUMBER) ORCH_ORDER_NUMBER, decode(dem.origination_type, 1030, nvl(dem.ORCH_ORDER_LINE_NUMBER, dem.SO_LINE_NUM), dem.ORCH_ORDER_LINE_NUMBER) ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, NULL BMT_FLAG, NULL DROP_SHIP_DEST_TYPE, decode(dem.demand_class, NULL, NULL, (select msc_get_name.msc_sr_lookup_meaning(dem.demand_class, 'DEMAND_CLASS') from dual)) DEMAND_CLASS_CODE, to_number(null) NET_SUPPLY_QTY_OVERRIDE, dem.lot_number LOT_NUMBER, to_number(null) IMPLEMENT_BILL_SEQUENCE_ID, to_number(null) IMPLEMENT_ROUTING_SEQUENCE_ID, dem.CARRIER_ID, dem.MODE_OF_TRANSPORT, dem.SERVICE_LEVEL, to_number(null) IMPLEMENT_CARRIER_ID, to_number(null) IMPLEMENT_MODE_OF_TRANSPORT, to_number(null) IMPLEMENT_SERVICE_LEVEL, to_char(null) IMPLEMENT_SHIP_METHOD_TEXT, dem.customer_po_number, dem.DAYS_PAST_DUE, dem.qty_satisfied_by_rdd, nvl(dem.EXPENSE_TRANSFER,2) EXPENSE_TRANSFER, dem.parent_model_item_id, decode(dem.parent_model_item_id, null,null, (select msc_get_name.item_name(dem.parent_model_item_id, null, null) from dual)) PARENT_MODEL_ITEM, dem.INVENTORY_ITEM_ID, to_number(NULL) new_order_quantity, to_number(NULL) SOURCE_SUPPLIER_ID, NULL PURCH_LINE_NUM, NULL TO_LINE_NUMBER, NULL TO_LINE_ID, dem.WIP_ENTITY_NAME, dem.PO_LINE_LOCATION_ID, to_number(NULL) pe_plan_id, to_number(NULL) pe_routing_sequence_id, to_number(NULL) 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 QTY_SCRAPPED, null EXPECTED_SCRAP_QTY, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) QTY_COMPLETED, DEM.BASE_PLAN_ID, (select msc_get_name.get_timezone_name(DEM.ORGANIZATION_ID) from dual) TIMEZONE_NAME, (select msc_get_name.get_timezone_code(DEM.ORGANIZATION_ID) from dual) TIMEZONE_CODE, (select msc_get_name.get_source_timezone_name(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) from dual) SOURCE_TIMEZONE_NAME, (select msc_get_name.get_source_timezone_code(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) from dual) SOURCE_TIMEZONE_CODE, (select msc_get_name.get_destination_timezone_name(dem.origination_type, dem.organization_id, null, dem.customer_site_id) from dual) DESTINATION_TIMEZONE_NAME, (select msc_get_name.get_destination_timezone_code(dem.origination_type, dem.organization_id, null, dem.customer_site_id) from dual) DESTINATION_TIMEZONE_CODE, to_number(null) ALT_FACILITY_USED, to_number(null) ALT_SUPPLIER_USED, to_number(null) ALT_WORK_DEFINITION_USED, to_number(null) ALT_RESOURCE_USED, to_number(null) SUBSTITUTE_COMPONENT_USED, to_number(null) CANCELED, NULL total_output_quantity, NULL last_op_completion_date, NULL work_method_code, NULL process_name, NULL BATCH_UOM, to_number(NULL) WORK_ORDER_SUB_TYPE, to_number(NULL) FIRM_START_QUANTITY1, dem.global_attribute_number11 GLOBAL_ATTR_NUMBER11S, dem.global_attribute_number12 GLOBAL_ATTR_NUMBER12S, dem.global_attribute_number13 GLOBAL_ATTR_NUMBER13S, dem.global_attribute_number14 GLOBAL_ATTR_NUMBER14S, dem.global_attribute_number15 GLOBAL_ATTR_NUMBER15S, dem.global_attribute_number16 GLOBAL_ATTR_NUMBER16S, dem.global_attribute_number17 GLOBAL_ATTR_NUMBER17S, dem.global_attribute_number18 GLOBAL_ATTR_NUMBER18S, dem.global_attribute_number19 GLOBAL_ATTR_NUMBER19S, dem.global_attribute_number20 GLOBAL_ATTR_NUMBER20S, dem.global_attribute_number21 GLOBAL_ATTR_NUMBER21S, dem.global_attribute_number22 GLOBAL_ATTR_NUMBER22S, dem.global_attribute_number23 GLOBAL_ATTR_NUMBER23S, dem.global_attribute_number24 GLOBAL_ATTR_NUMBER24S, dem.global_attribute_number25 GLOBAL_ATTR_NUMBER25S, dem.global_attribute_number26 GLOBAL_ATTR_NUMBER26S, dem.global_attribute_number27 GLOBAL_ATTR_NUMBER27S, dem.global_attribute_number28 GLOBAL_ATTR_NUMBER28S, dem.global_attribute_number29 GLOBAL_ATTR_NUMBER29S, dem.global_attribute_number30 GLOBAL_ATTR_NUMBER30S, dem.global_attribute_number31 GLOBAL_ATTR_NUMBER31S, dem.global_attribute_number32 GLOBAL_ATTR_NUMBER32S, dem.global_attribute_number33 GLOBAL_ATTR_NUMBER33S, dem.global_attribute_number34 GLOBAL_ATTR_NUMBER34S, dem.global_attribute_number35 GLOBAL_ATTR_NUMBER35S, dem.global_attribute_number36 GLOBAL_ATTR_NUMBER36S, dem.global_attribute_number37 GLOBAL_ATTR_NUMBER37S, dem.global_attribute_number38 GLOBAL_ATTR_NUMBER38S, dem.global_attribute_number39 GLOBAL_ATTR_NUMBER39S, dem.global_attribute_number40 GLOBAL_ATTR_NUMBER40S, dem.GLOBAL_ATTRIBUTE_CHAR21 GLOBAL_ATTRIBUTE_CHAR21S, dem.GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR22S, dem.GLOBAL_ATTRIBUTE_CHAR23 GLOBAL_ATTRIBUTE_CHAR23S, decode(dem.IMPLEMENT_ORG_ID, null, null, (select msc_get_name.org_code(dem.IMPLEMENT_ORG_ID) from dual)) implement_source_org, to_char(null) IMPLEMENT_SUPPLIER, to_char(null) IMPLEMENT_SUPPLIER_SITE, (select MSC_SPUI_COMMON.GET_ORG_CURRENCY_CODE(dem.ORGANIZATION_ID) from dual) ORG_CURRENCY_CODE, to_number(null) QTY_REMAINING, dem.ISSUED_QUANTITY, to_number(dem.configured_item) CONFIGURED_ITEM, decode(dem.configured_item, null, null, (select msc_get_name.item_name(dem.configured_item, NULL, NULL) from dual)) CONFIGURED_ITEM_NAME, dem.asset_number, null drop_ship_customer, null drop_ship_customer_site, null receipt_number, null revision, to_number(null) delivery_price, to_char(null) schedule_line_number, null shipment_line_number, null shipment_header_number, null 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 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 Minimum_Percentage_For_Split, DEM.MIN_QUANTITY_FOR_SPLIT Minimum_Quantity_For_Split, DEM.MIN_REM_SHELF_LIFE_DAYS Minimum_Remaining_Shelf_Life, DEM.ORDER_MARGIN, DEM.PARENT_FULFILLMENT_LINE, DEM.PROMISING_SYSTEM, DEM.ROOT_FULFILLMENT_LINE, DEM.SALESREP_CONTACT Sales_Representative_Contact, DEM.SHIPPING_PREFERENCE, DEM.SUPPLIER_SITE_SOURCE_SYSTEM_ID SUPPLIER_SITE_SOURCE_SYSTEM, to_date(null) HOLD_DATE1, to_char(null) implement_location_code, to_date(null) MATURITY_DATE, to_date(null) MATURITY_DATE1, to_number(null) CUMULATIVE_YIELD 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 CONTRIBUTES_DMD_LATENESS, null SHARED_SUPPLY, null CONTRIBUTES_OVERLOAD, null CONSUMPTION_START_DATE, null USES_ORDER_MODIFIER, null LATEST_START_DATE, null PEGGED_TO_FIRM, null 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 SIMULATION_SET_NAME, MscOrderUpdateEO.HOLD_DATE, to_date(NULL) ACTUAL_START_DATE, NULL ALTERNATE_BOM_DESIGNATOR, NULL ALTERNATE_ROUTING_DESIGNATOR, dem.APPLIED, dem.arrival_set_id, dem.arrival_set_name, to_number(NULL) 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( (select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG',dem.bucket_type) from dual),null, (select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_GREGORIAN',dem.bucket_type) from dual), (select msc_get_name.lookup_meaning('ORA_MSC_TIME_LEVELS_MFG', dem.bucket_type) from dual))) BUCKET_TYPE, to_number(NULL) BUILD_SEQUENCE, NULL BUYER_NAME, NULL COMMENTS, dem.CREATED_BY CREATED_BY1, dem.CREATION_DATE CREATION_DATE1, dem.customer_id, dem.customer_site_id, decode(dem.customer_site_id, null,null, (select msc_get_name.customer_site( dem.customer_site_id) from dual)) CUSTOMER_SITE_NAME, dem.demand_class, DECODE(dem.plan_id,-1, dem.order_priority, dem.demand_priority) DEMAND_PRIORITY, dem.override_demand_priority, (select msc_get_name.designator(dem.schedule_designator_id) from dual) DESIGNATOR_NAME, to_number(NULL) DEST_INST_ID, NULL DEST_ORG_CODE, to_number(NULL) DEST_ORG_ID, dem.DISPOSITION_ID, TO_NUMBER(NULL) DISPOSITION_STATUS_TYPE, dem.DMD_SATISFIED_DATE, dem.EXPIRATION_DATE, dem.FIRM_DATE FIRM_DATE1, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) FIRM_PLANNED_TYPE1, dem.FIRM_QUANTITY FIRM_QUANTITY1, NULL IMPLEMENT_ALTERNATE_BOM, NULL IMPLEMENT_ALTERNATE_ROUTING, dem.IMPLEMENT_ARRIVAL_DATE, TO_NUMBER(NULL) IMPLEMENT_AS, NULL IMPLEMENT_AS_TEXT, to_number(NULL) IMPLEMENT_BUILD_SEQUENCE, dem.IMPLEMENT_DATE, NULL IMPLEMENT_DEMAND_CLASS, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, to_number(NULL) IMPLEMENT_DEST_ORG_ID, to_date(NULL) IMPLEMENT_DOCK_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, to_number(NULL) IMPLEMENT_EMPLOYEE_ID, dem.IMPLEMENT_FIRM, NULL IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, TO_NUMBER(NULL) IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, to_number(NULL) IMPLEMENT_PROJECT_ID, TO_NUMBER(NULL) IMPLEMENT_QUANTITY_RATE, to_number(NULL) IMPLEMENT_SCHEDULE_GROUP_ID, dem.IMPLEMENT_SHIP_DATE, NULL IMPLEMENT_SHIP_METHOD, dem.implement_org_id IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) IMPLEMENT_STATUS_CODE, to_number(NULL) IMPLEMENT_TASK_ID, NULL IMPLEMENT_UNIT_NUMBER, TO_NUMBER(NULL) IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_SITE_ID, TO_CHAR(NULL) IMPLEMENT_WIP_CLASS_CODE, TO_NUMBER(NULL) IMPLEMENTED_QUANTITY, DECODE(NULL, 1, 1,2) IN_SOURCE_PLAN, NULL INTRANSIT_CALENDAR, dem.INTRANSIT_LEAD_TIME, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) from dual) ORDER_TYPE_TEXT, MscOrderUpdateEO.FIRM_PLANNED_TYPE, dem.USING_ASSEMBLY_DEMAND_DATE 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) ORDER_NUMBER, decode(dem.customer_id, null,null, (select msc_get_name.customer(dem.customer_id) from dual)) CUSTOMER_NAME, NVL(dem.RELEASE_STATUS,-1) RELEASE_STATUS, dem.planned_ship_date SHIP_DATE, TO_DATE(NULL) LAST_UNIT_COMPLETION_DATE, dem.LAST_UPDATE_DATE LAST_UPDATE_DATE1, dem.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN1, dem.LAST_UPDATED_BY LAST_UPDATED_BY1, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL) latest_acceptable_date, TO_NUMBER(NULL) LINE_ID, dem.LOAD_TYPE, NULL LOTS_EXIST, to_date(NULL) NEED_BY_DATE, TO_DATE(NULL) NEW_DOCK_DATE, TO_DATE(NULL) NEW_ORDER_DATE, TO_DATE(NULL) NEW_START_DATE, to_date(NULL) OLD_DOCK_DATE, dem.OLD_DEMAND_DATE OLD_DUE_DATE, to_date(NULL) OLD_NEED_BY_DATE, dem.OLD_DEMAND_QUANTITY OLD_ORDER_QUANTITY, dem.ORDER_DATE_TYPE_CODE, (select msc_get_name.lookup_meaning('ORA_MSC_ORDER_DATE_TYPE_CODE', DECODE( dem.ORDER_DATE_TYPE_CODE, NULL, 1, dem.ORDER_DATE_TYPE_CODE)) from dual) ORDER_DATE_TYPE_TEXT, dem.origination_type ORDER_TYPE, dem.ORGANIZATION_ID, dem.original_inst_id, dem.original_item_id, decode(dem.original_item_id, NULL, NULL, (select msc_get_name.item_name(dem.original_item_id, NULL, NULL) from dual)) ORIGINAL_ITEM_NAME, dem.original_quantity ORIGINAL_ITEM_QTY, to_date(NULL) ORIGINAL_NEED_BY_DATE, dem.original_org_id, dem.using_requirement_quantity+nvl(dem.completed_quantity,0) ORIGINAL_QUANTITY, to_date(NULL) PLAN_CUTOFF_DATE, dem.PLAN_ID, to_number(NULL) PLAN_INSTANCE_ID, to_number(NULL) PLAN_ORGANIZATION_ID, to_date(NULL) PLAN_START_DATE, dem.PLANNED_ARRIVAL_DATE, dem.probability, to_number(NULL) PROCESS_SEQ_ID, dem.PROJECT_ID, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) PROMISE_DATE, dem.promise_ship_date, dem.quantity_by_due_date*NVL(dem.probability, 1) QTY_BY_DUE_DATE, -dem.using_requirement_quantity QUANTITY, TO_NUMBER(NULL) QUANTITY_IN_PROCESS, -NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) QUANTITY_RATE, NULL RECEIVING_CALENDAR, dem.RECORD_SOURCE, dem.RELEASE_ERRORS, NULL REPETITIVE_TYPE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) REQUEST_DATE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 1, dem.request_date, null),dem.request_ship_date) REQUEST_SHIP_DATE, to_date(NULL) REQUESTED_COMPLETION_DATE, to_number(NULL) RESCHEDULE_DAYS, dem.RESCHEDULE_FLAG RESCHEDULED_FLAG, dem.reserved_quantity, to_number(NULL) ROUTING_SEQUENCE_ID, dem.ROWID ROW_ID, dem.sales_order_line_id, dem.SCHEDULE_ARRIVAL_DATE, to_number(NULL) SCHEDULE_COMPRESSION_DAYS, dem.SCHEDULE_DESIGNATOR_ID, to_number(NULL) SCHEDULE_GROUP_ID, NULL SCHEDULE_GROUP_NAME, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) 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)) ship_method_text, dem.ship_set_id, dem.ship_set_name, dem.ship_to_site_id, decode(dem.ship_to_site_id, NULL, NULL, (select msc_get_name.customer_site(dem.ship_to_site_id) from dual)) SHIP_TO_SITE_NAME, to_number(NULL) 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)) SOURCE_DMD_PRIORITY, DECODE(dem.supply_id, NULL, DECODE(dem.origination_type, 1006, DECODE( (select msc_get_name.order_type(dem.plan_id, dem.disposition_id ) from dual), 2, NULL, (select msc_get_name.org_code(dem.source_organization_id) from dual)), 1030, DECODE( (select msc_get_name.order_type( dem.plan_id, dem.disposition_id) from dual), 2, NULL, (select msc_get_name.org_code(dem.source_organization_id) from dual)), (select msc_get_name.org_code( dem.source_organization_id) from dual)), NULL ) SOURCE_ORGANIZATION_CODE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id SOURCE_SR_INSTANCE_ID, 'MSC_DEMANDS' SOURCE_TABLE2, decode(dem.supplier_id, NULL, NULL, (select msc_get_name.supplier(dem.supplier_id) from dual)) SOURCE_VENDOR_NAME, decode(dem.supplier_site_id, NULL, NULL, (select msc_get_name.supplier_site(dem.supplier_site_id) from dual)) SOURCE_VENDOR_SITE_CODE, TO_NUMBER(NULL) STATUS_CODE, dem.sub_inventory_code SUBINVENTORY_CODE, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, to_date(NULL) SUGGESTED_PICK_DATE, NULL SUPPLIER_NAME, NULL SUPPLIER_SITE_CODE, dem.TASK_ID, dem.DEMAND_ID TRANSACTION_ID1, dem.UNIT_NUMBER, dem.unmet_quantity, dem.USING_ASSEMBLY_ITEM_ID, decode(dem.using_assembly_item_id, -1, NULL, (select msc_get_name.item_name(dem.using_assembly_item_id, NULL, NULL) from dual)) USING_ASSEMBLY_SEGMENTS, dem.supplier_id VENDOR_ID, dem.supplier_site_id VENDOR_SITE_ID, to_number(NULL) START_QUANTITY, to_number(NULL) WIP_STATUS_CODE, NULL WIP_STATUS_TEXT, dem.days_late LATE_DAYS, to_number(NULL) CTB_COMP_AVAIL_PERCENT, to_date(NULL) CTB_EXPECTED_DATE, TO_CHAR(NULL) CTB_FLAG, to_number(NULL) CTB_PRIORITY, to_date(NULL) FIRM_START_DATE, to_number(NULL) 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, (select msc_get_name.get_zone_name(dem.zone_id) from dual)) ZONE, dem.SO_LINE_NUM, decode(dem.origination_type, 1030, dem.sales_order_number, dem.ORCH_ORDER_NUMBER) ORCH_ORDER_NUMBER, decode(dem.origination_type, 1030, nvl(dem.ORCH_ORDER_LINE_NUMBER, dem.SO_LINE_NUM), dem.ORCH_ORDER_LINE_NUMBER) ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, NULL BMT_FLAG, NULL DROP_SHIP_DEST_TYPE, decode(dem.demand_class, null, null, (select msc_get_name.msc_sr_lookup_meaning(dem.demand_class, 'DEMAND_CLASS') from dual)) DEMAND_CLASS_CODE, to_number(null) NET_SUPPLY_QTY_OVERRIDE, dem.lot_number LOT_NUMBER, to_number(null) IMPLEMENT_BILL_SEQUENCE_ID, to_number(null) IMPLEMENT_ROUTING_SEQUENCE_ID, dem.CARRIER_ID, dem.MODE_OF_TRANSPORT, dem.SERVICE_LEVEL, to_number(null) IMPLEMENT_CARRIER_ID, to_number(null) IMPLEMENT_MODE_OF_TRANSPORT, to_number(null) IMPLEMENT_SERVICE_LEVEL, to_char(null) IMPLEMENT_SHIP_METHOD_TEXT, dem.customer_po_number, dem.DAYS_PAST_DUE, dem.qty_satisfied_by_rdd, nvl(dem.EXPENSE_TRANSFER,2) EXPENSE_TRANSFER, dem.parent_model_item_id, decode(dem.parent_model_item_id, null,null, (select msc_get_name.item_name(dem.parent_model_item_id, null, null) from dual)) PARENT_MODEL_ITEM, dem.INVENTORY_ITEM_ID, to_number(NULL) new_order_quantity, to_number(NULL) SOURCE_SUPPLIER_ID, NULL PURCH_LINE_NUM, NULL TO_LINE_NUMBER, NULL TO_LINE_ID, dem.WIP_ENTITY_NAME, dem.PO_LINE_LOCATION_ID, to_number(NULL) pe_plan_id, to_number(NULL) pe_routing_sequence_id, to_number(NULL) 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 QTY_SCRAPPED, null EXPECTED_SCRAP_QTY, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) QTY_COMPLETED, DEM.BASE_PLAN_ID, (select msc_get_name.get_timezone_name(DEM.ORGANIZATION_ID) from dual) TIMEZONE_NAME, (select msc_get_name.get_timezone_code(DEM.ORGANIZATION_ID) from dual) TIMEZONE_CODE, (select msc_get_name.get_source_timezone_name(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) from dual) SOURCE_TIMEZONE_NAME, (select msc_get_name.get_source_timezone_code(dem.origination_type, dem.organization_id, null, dem.supplier_site_id) from dual) SOURCE_TIMEZONE_CODE, (select msc_get_name.get_destination_timezone_name(dem.origination_type, dem.organization_id, null, dem.customer_site_id) from dual) DESTINATION_TIMEZONE_NAME, (select msc_get_name.get_destination_timezone_code(dem.origination_type, dem.organization_id, null, dem.customer_site_id) from dual) DESTINATION_TIMEZONE_CODE, to_number(null) ALT_FACILITY_USED, to_number(null) ALT_SUPPLIER_USED, to_number(null) ALT_WORK_DEFINITION_USED, to_number(null) ALT_RESOURCE_USED, to_number(null) SUBSTITUTE_COMPONENT_USED, to_number(null) CANCELED, NULL total_output_quantity, NULL last_op_completion_date, NULL work_method_code, NULL process_name, NULL BATCH_UOM, to_number(NULL) WORK_ORDER_SUB_TYPE, to_number(NULL) FIRM_START_QUANTITY1, dem.global_attribute_number11 GLOBAL_ATTR_NUMBER11S, dem.global_attribute_number12 GLOBAL_ATTR_NUMBER12S, dem.global_attribute_number13 GLOBAL_ATTR_NUMBER13S, dem.global_attribute_number14 GLOBAL_ATTR_NUMBER14S, dem.global_attribute_number15 GLOBAL_ATTR_NUMBER15S, dem.global_attribute_number16 GLOBAL_ATTR_NUMBER16S, dem.global_attribute_number17 GLOBAL_ATTR_NUMBER17S, dem.global_attribute_number18 GLOBAL_ATTR_NUMBER18S, dem.global_attribute_number19 GLOBAL_ATTR_NUMBER19S, dem.global_attribute_number20 GLOBAL_ATTR_NUMBER20S, dem.global_attribute_number21 GLOBAL_ATTR_NUMBER21S, dem.global_attribute_number22 GLOBAL_ATTR_NUMBER22S, dem.global_attribute_number23 GLOBAL_ATTR_NUMBER23S, dem.global_attribute_number24 GLOBAL_ATTR_NUMBER24S, dem.global_attribute_number25 GLOBAL_ATTR_NUMBER25S, dem.global_attribute_number26 GLOBAL_ATTR_NUMBER26S, dem.global_attribute_number27 GLOBAL_ATTR_NUMBER27S, dem.global_attribute_number28 GLOBAL_ATTR_NUMBER28S, dem.global_attribute_number29 GLOBAL_ATTR_NUMBER29S, dem.global_attribute_number30 GLOBAL_ATTR_NUMBER30S, dem.global_attribute_number31 GLOBAL_ATTR_NUMBER31S, dem.global_attribute_number32 GLOBAL_ATTR_NUMBER32S, dem.global_attribute_number33 GLOBAL_ATTR_NUMBER33S, dem.global_attribute_number34 GLOBAL_ATTR_NUMBER34S, dem.global_attribute_number35 GLOBAL_ATTR_NUMBER35S, dem.global_attribute_number36 GLOBAL_ATTR_NUMBER36S, dem.global_attribute_number37 GLOBAL_ATTR_NUMBER37S, dem.global_attribute_number38 GLOBAL_ATTR_NUMBER38S, dem.global_attribute_number39 GLOBAL_ATTR_NUMBER39S, dem.global_attribute_number40 GLOBAL_ATTR_NUMBER40S, dem.GLOBAL_ATTRIBUTE_CHAR21 GLOBAL_ATTRIBUTE_CHAR21S, dem.GLOBAL_ATTRIBUTE_CHAR22 GLOBAL_ATTRIBUTE_CHAR22S, dem.GLOBAL_ATTRIBUTE_CHAR23 GLOBAL_ATTRIBUTE_CHAR23S, decode(dem.IMPLEMENT_ORG_ID, null, null, (select msc_get_name.org_code(dem.IMPLEMENT_ORG_ID) from dual)) implement_source_org, to_char(null) IMPLEMENT_SUPPLIER, to_char(null) IMPLEMENT_SUPPLIER_SITE, (select MSC_SPUI_COMMON.GET_ORG_CURRENCY_CODE(dem.ORGANIZATION_ID) from dual) ORG_CURRENCY_CODE, to_number(null) QTY_REMAINING, dem.issued_quantity, to_number(dem.configured_item) CONFIGURED_ITEM, decode(dem.configured_item, null, null, (select msc_get_name.item_name(dem.configured_item, NULL, NULL) from dual)) CONFIGURED_ITEM_NAME, dem.asset_number, null drop_ship_customer, null drop_ship_customer_site, null receipt_number, null revision, to_number(null) delivery_price, to_char(null) schedule_line_number, null shipment_line_number, null shipment_header_number, null 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 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 Minimum_Percentage_For_Split, DEM.MIN_QUANTITY_FOR_SPLIT Minimum_Quantity_For_Split, DEM.MIN_REM_SHELF_LIFE_DAYS Minimum_Remaining_Shelf_Life, DEM.ORDER_MARGIN, DEM.PARENT_FULFILLMENT_LINE, DEM.PROMISING_SYSTEM, DEM.ROOT_FULFILLMENT_LINE, DEM.SALESREP_CONTACT Sales_Representative_Contact, DEM.SHIPPING_PREFERENCE, DEM.SUPPLIER_SITE_SOURCE_SYSTEM_ID SUPPLIER_SITE_SOURCE_SYSTEM, to_date(null) HOLD_DATE1, to_char(null) implement_location_code, to_date(null) MATURITY_DATE, to_date(null) MATURITY_DATE1, to_number(null) CUMULATIVE_YIELD 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 )