MSC_PEGGING_SUPPLY2_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

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

Query

SQL_Statement

SELECT /*+ORDERED index(sup,MSC_SUPPLIES_U1) */ 'MSC_SUPPLIES' SOURCE_TABLE, sup.ROWID ROW_ID, mfp1.dest_transaction_id TRANSACTION_ID, sup.LAST_UPDATE_DATE, sup.LAST_UPDATED_BY, sup.CREATION_DATE, sup.CREATED_BY, sup.LAST_UPDATE_LOGIN, sup.INVENTORY_ITEM_ID, sup.ORGANIZATION_ID, msi.organization_code, to_number(NULL) PLAN_ORGANIZATION_ID, to_number(NULL) PLAN_INSTANCE_ID, mfp1.plan_id, mp.compile_designator, sup.NEW_SCHEDULE_DATE NEW_DUE_DATE, sup.OLD_SCHEDULE_DATE OLD_DUE_DATE, sup.NEW_WIP_START_DATE NEW_START_DATE, sup.DISPOSITION_ID, msc_get_name.supply_order_number_new (sup.order_type, sup.order_number, sup.transaction_id, sup.disposition_id, sup.fg_order_type) ORDER_NUMBER, sup.DISPOSITION_STATUS_TYPE, sup.ORDER_TYPE, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) from dual) ORDER_TYPE_TEXT, NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) QUANTITY_RATE, sup.OLD_ORDER_QUANTITY, NVL(sup.NEW_ORDER_PLACEMENT_DATE , sup.firm_date) NEW_ORDER_DATE, sup.FIRM_PLANNED_TYPE, sup.RESCHEDULE_FLAG RESCHEDULED_FLAG, sup.IMPLEMENTED_QUANTITY, sup.LAST_UNIT_COMPLETION_DATE, sup.NEW_DOCK_DATE, sup.QUANTITY_IN_PROCESS, sup.FIRM_QUANTITY, sup.FIRM_DATE, sup.LINE_ID, sup.IMPLEMENT_DEMAND_CLASS, msi.item_name ITEM_SEGMENTS, sup.IMPLEMENT_DATE, NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) IMPLEMENT_QUANTITY_RATE, sup.IMPLEMENT_FIRM, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, sup.IMPLEMENT_WIP_CLASS_CODE, sup.IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, sup.IMPLEMENT_STATUS_CODE, sup.IMPLEMENT_LOCATION_ID, sup.RELEASE_STATUS, 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, msi.PLANNER_CODE, to_number(NULL) USING_ASSEMBLY_ITEM_ID, msi.MRP_PLANNING_CODE, NULL REPETITIVE_TYPE, msi.BUILD_IN_WIP_FLAG, msi.PURCHASING_ENABLED_FLAG, msi.PLANNING_MAKE_BUY_CODE, msi.BOM_ITEM_TYPE, msi.BASE_ITEM_ID, msi.WIP_SUPPLY_TYPE, sup.SOURCE_ORGANIZATION_ID, NULL SOURCE_SR_INSTANCE_ID, decode(sup.source_organization_id, NULL, NULL, (select msc_get_name.org_code(sup.source_organization_id) from dual)) SOURCE_ORGANIZATION_CODE, sup.wip_status_code STATUS_CODE, NULL USING_ASSEMBLY_SEGMENTS, 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.supplier_id VENDOR_ID, NULL SUPPLIER_NAME, sup.supplier_site_id VENDOR_SITE_ID, NULL SUPPLIER_SITE_CODE, sup.IMPLEMENT_SOURCE_ORG_ID, NULL IMPLEMENT_SR_INSTANCE_ID, sup.implement_supplier_id IMPLEMENT_VENDOR_ID, sup.implement_supplier_site_id IMPLEMENT_VENDOR_SITE_ID, 2 IN_SOURCE_PLAN, sup.schedule_compress_days SCHEDULE_COMPRESSION_DAYS, sup.project_id, sup.task_id, sup.implement_project_id, sup.implement_task_id, sup.applied, msi.release_time_fence_code, sup.implement_schedule_group_id, sup.implement_build_sequence, DECODE(sup.ORDER_TYPE, 3, sup.BUILD_SEQUENCE, 7, sup.BUILD_SEQUENCE, 14, sup.BUILD_SEQUENCE, 15, sup.BUILD_SEQUENCE, 27, sup.BUILD_SEQUENCE, to_number( NULL)) BUILD_SEQUENCE, DECODE(sup.ORDER_TYPE, 3, sup.SCHEDULE_GROUP_ID, 7, sup.SCHEDULE_GROUP_ID, 14, sup.SCHEDULE_GROUP_ID, 15, sup.SCHEDULE_GROUP_ID, 27, sup.SCHEDULE_GROUP_ID, to_number(NULL)) SCHEDULE_GROUP_ID, sup.alternate_bom_designator, sup.alternate_routing_designator, sup.process_seq_id, sup.implement_alternate_bom, sup.implement_alternate_routing, sup.schedule_group_name, sup.implement_employee_id, to_number(NULL) CFM_ROUTING_FLAG, msi.BUYER_NAME, sup.release_errors, sup.unit_number, sup.implement_unit_number, msi.description, msi.product_family_id, decode(msi.product_family_id, NULL, NULL, (select msc_get_name.item_name(msi.product_family_id,NULL,NULL) from dual)) PRODUCT_FAMILY_NAME, NULL BASE_ITEM_NAME, msi.uom_code, DECODE(mp.plan_type, 5, to_number(NULL), sup.schedule_priority) DEMAND_PRIORITY, NULL OVERRIDE_DEMAND_PRIORITY, sup.promised_date PROMISE_DATE, decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) REQUEST_DATE, sup.drop_ship_cust_id CUSTOMER_ID, decode(sup.drop_ship_cust_id, NULL, NULL, (select msc_get_name.customer(sup.drop_ship_cust_id) from dual)) CUSTOMER_NAME, sup.drop_ship_cust_site_id CUSTOMER_SITE_ID, decode(sup.drop_ship_cust_site_id, NULL, NULL, (select msc_get_name.customer_site(sup.drop_ship_cust_site_id) from dual)) CUSTOMER_SITE_NAME, to_number(NULL) SHIP_TO_SITE_ID, NULL SHIP_TO_SITE_NAME, sup.lot_number, sup.subinventory_code, 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, to_date(NULL) DMD_SATISFIED_DATE, sup.need_by_date, NVL(sup.schedule_designator, (select msc_get_name.designator(sup.schedule_designator_id, null, sup.plan_id) from dual)) DESIGNATOR_NAME, to_number(NULL) SELLING_PRICE, DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) DEMAND_CLASS, to_number(NULL) PROBABILITY, sup.new_ship_date SHIP_DATE, sup.new_order_quantity QUANTITY, NULL BUCKET_TYPE, to_number(NULL) SOURCE_DMD_PRIORITY, sup.reschedule_days, DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) OLD_NEED_BY_DATE, to_number(NULL) ORIGINAL_ITEM_ID, NULL ORIGINAL_ITEM_NAME, to_number(NULL) ORIGINAL_ITEM_QTY, sup.ship_method, to_number(NULL) UNMET_QUANTITY, sup.original_quantity, sup.original_need_by_date, sup.earliest_start_date, sup.Consumption_Start_Date, sup.Contributes_Overload, sup.Contributes_dmd_lateness, sup.Shared_Supply, sup.Uses_Order_Modifier, sup.Pegged_to_Firm, sup.Material_Avail_Date, sup.Latest_Start_Date, sup.record_source, sup.start_quantity, sup.expiration_date, (select msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE',msi.mrp_planning_code) from dual) MRP_PLANNING_CODE_TEXT, to_number(NULL) ORIGINAL_ORG_ID, to_number(NULL) ORIGINAL_INST_ID, to_number(NULL) ORDER_DATE_TYPE_CODE, TO_CHAR(NULL) ORDER_DATE_TYPE_TEXT, to_date(NULL) SCHEDULE_ARRIVAL_DATE, to_date(NULL) LATEST_ACCEPTABLE_DATE, to_date(NULL) PLANNED_ARRIVAL_DATE, sup.shipment_id, sup.ship_calendar, sup.receiving_calendar, sup.intransit_calendar, sup.intransit_lead_time, sup.implement_dock_date, sup.implement_ship_date, to_date(NULL) IMPLEMENT_ARRIVAL_DATE, decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) REQUEST_SHIP_DATE, decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) PROMISE_SHIP_DATE, sup.days_late LATE_DAYS, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, 'MSC_SUPPLIES' SOURCE_TABLE2, to_date(NULL) SCHEDULE_SHIP_DATE, NULL DEST_ORG_CODE, to_number(NULL) QTY_BY_DUE_DATE, NULL SHIP_SET_NAME, NULL ARRIVAL_SET_NAME, to_number(NULL) DEST_ORG_ID, to_number(NULL) DEST_INST_ID, to_number(NULL) IMPLEMENT_DEST_ORG_ID, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, decode(sup.zone_id, NULL, NULL, (select msc_get_name.get_zone_name(sup.zone_id) from dual)) ZONE, sup.requested_completion_date, NULL LOTS_EXIST, sup.implement_ship_method, sup.actual_start_date, to_date(NULL) IMPLEMENT_DUE_DATE, to_number(NULL) SCHEDULE_DESIGNATOR_ID, to_number(NULL) sales_order_line_id, to_number(NULL) ship_set_id, to_number(NULL) arrival_set_id, sup.firm_start_date, sup.bill_sequence_id, sup.routing_sequence_id, NULL COMMENTS, mfp1.allocated_quantity, mfp1.prev_pegging_id pegging_id, mfp1.end_pegging_id, mfp1.demand_id up_level_demand_id, mfp1.transaction_id up_level_transaction_id, mfp1.organization_id up_level_organization_id, mfp1.inventory_item_id up_level_inventory_item_id, mfp1.pegging_id up_level_pegging_id, mfp1.prev_pegging_id up_level_prev_pegging_id, mfp1.end_pegging_id up_level_end_pegging_id, sup.load_type, msi.plan_id base_plan_id, msi.rounding_control_type, sup.OLD_DOCK_DATE, NULL plan_cutoff_date, NULL plan_start_date, sup.reserved_quantity, sup.CTB_FLAG, sup.CTB_COMP_AVAIL_PERCENT, sup.RTB_ORDER_QTY_PERCENT, sup.CTB_EXPECTED_DATE, sup.CTB_PRIOIRTY CTB_PRIORITY, to_date(NULL) revised_dmd_date, to_number(NULL) revised_dmd_priority, nvl(sup.ship_method, (select msc_get_name.get_ship_method(sup.carrier_id, sup.mode_of_transport, sup.service_level) from dual)) ship_method_text, sup.ORIG_FIRM_DATE, sup.ORIG_FIRM_QUANTITY, 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, mfp1.PEGGING_TYPE, sup.BMT_FLAG, sup.DROP_SHIP_DEST_TYPE, MSC_SPUI_COMMON.release_action ('MSC_SUPPLIES',sup.plan_id,sup.ORGANIZATION_ID,sup.INVENTORY_ITEM_ID,sup.ORDER_TYPE,sup.TRANSACTION_ID,msi.PURCHASING_ENABLED_FLAG,nvl(sup.RESCHEDULE_FLAG,2),nvl(sup.reschedule_days,0),msi.release_time_fence_code,msi.BUILD_IN_WIP_FLAG,sup.SOURCE_ORGANIZATION_ID,sup.new_order_quantity,sup.FIRM_QUANTITY,sup.RELEASE_STATUS,msi.wip_supply_type,msi.BOM_ITEM_TYPE,msi.PLANNING_MAKE_BUY_CODE,sup.implemented_quantity,sup.original_quantity,sup.DISPOSITION_STATUS_TYPE,sup.reserved_quantity,sup.routing_sequence_id,msi.PLANNER_CODE,sup.FIRM_PLANNED_TYPE,sup.applied,sup.drop_ship_dest_type,msi.back_to_back_flag,msi.in_source_plan,sup.fg_order_type,sup.allow_tol_cancel_release,sup.release_errors) release_action, msi.back_to_back_flag, 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.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, (select msc_get_name.get_ship_method(sup.implement_carrier_id, sup.implement_mode_of_transport_id, sup.implement_service_level_id) from dual)) IMPLEMENT_SHIP_METHOD_TEXT, to_char(null) CUSTOMER_PO_NUMBER, decode(sup.bill_sequence_id, NULL, NULL, (select msc_get_name.get_item_structure_name(msi.plan_id, sup.bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) ITEM_STRUCTURE_NAME, CASE WHEN (sup.routing_sequence_id IS NULL AND sup.bill_sequence_id IS NULL ) THEN NULL WHEN (sup.routing_sequence_id IS NULL AND sup.bill_sequence_id IS NOT NULL ) THEN 'NotAvailable' ELSE (select msc_get_name.get_work_definition(msi.plan_id, sup.routing_sequence_id, sup.organization_id, msi.SIMULATION_SET_ID) from dual) END WORK_DEFINITION, decode(sup.implement_bill_sequence_id, NULL, NULL, (select msc_get_name.get_item_structure_name(msi.plan_id, sup.implement_bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) IMPLEMENT_ITEM_STRUCTURE, decode(sup.implement_routing_sequence_id, NULL, NULL, (select msc_get_name.get_work_definition(msi.plan_id, sup.implement_routing_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) IMPLEMENT_WORK_DEFINITION, 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.QTY_COMPLETED, SUP.QTY_SCRAPPED, SUP.EXPECTED_SCRAP_QTY, SUP.FIRM_START_QUANTITY, (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.operation_seq_num, 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, msi.hard_pegging_level, sup.GLOBAL_ATTRIBUTE_NUMBER11, sup.GLOBAL_ATTRIBUTE_NUMBER12, sup.GLOBAL_ATTRIBUTE_NUMBER13, sup.GLOBAL_ATTRIBUTE_NUMBER14, sup.GLOBAL_ATTRIBUTE_NUMBER15, sup.GLOBAL_ATTRIBUTE_NUMBER16, sup.GLOBAL_ATTRIBUTE_NUMBER17, sup.GLOBAL_ATTRIBUTE_NUMBER18, sup.GLOBAL_ATTRIBUTE_NUMBER19, sup.GLOBAL_ATTRIBUTE_NUMBER20, sup.GLOBAL_ATTRIBUTE_NUMBER21, sup.GLOBAL_ATTRIBUTE_NUMBER22, sup.GLOBAL_ATTRIBUTE_NUMBER23, sup.GLOBAL_ATTRIBUTE_NUMBER24, sup.GLOBAL_ATTRIBUTE_NUMBER25, sup.GLOBAL_ATTRIBUTE_NUMBER26, sup.GLOBAL_ATTRIBUTE_NUMBER27, sup.GLOBAL_ATTRIBUTE_NUMBER28, sup.GLOBAL_ATTRIBUTE_NUMBER29, sup.GLOBAL_ATTRIBUTE_NUMBER30, sup.GLOBAL_ATTRIBUTE_NUMBER31, sup.GLOBAL_ATTRIBUTE_NUMBER32, sup.GLOBAL_ATTRIBUTE_NUMBER33, sup.GLOBAL_ATTRIBUTE_NUMBER34, sup.GLOBAL_ATTRIBUTE_NUMBER35, sup.GLOBAL_ATTRIBUTE_NUMBER36, sup.GLOBAL_ATTRIBUTE_NUMBER37, sup.GLOBAL_ATTRIBUTE_NUMBER38, sup.GLOBAL_ATTRIBUTE_NUMBER39, sup.GLOBAL_ATTRIBUTE_NUMBER40, 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, decode(msi.PLANNER_CODE, NULL, NULL, (select msc_get_name.get_planner_desc(msi.PLANNER_CODE) from dual)) PLANNER_DESCRIPTION, sup.asset_number, msi.segment_id, decode(msi.segment_id, NULL, NULL, (select msc_get_name.segment_name(msi.segment_id) from dual)) SEGMENT_NAME, mfp1.net_seq_num, to_number(null) original_transaction_id, sup.hold_date HOLD_DATE, case when sup.order_type in (3) then sup.wip_status_code * 10000 when sup.order_type in (1,3,94) then sup.order_status else null end order_status, decode(sup.implement_location_id, null, null, (select msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) from dual)) implement_location_code, sup.child_organization_id, decode(sup.child_organization_id, NULL, NULL, (select msc_get_name.org_code(sup.child_organization_id) from dual)) child_organization_code, sup.original_subinventory_code, SUP.ATTRIBUTE_ROW_ID, sup.fg_order_type, sup.maturity_date, sup.constrained_start_date, sup.cumulative_yield, sup.mtq_supply_date FROM msc_full_pegging mfp1, msc_plan_definitions mp, MSC_SUPPLIES SUP, msc_system_items msi WHERE mfp1.plan_id = mp.plan_id AND mfp1.plan_id = sup.plan_id AND mfp1.dest_transaction_id = sup.transaction_id AND mfp1.prev_pegging_id is not null AND sup.base_plan_id = msi.plan_id AND sup.ORGANIZATION_ID = msi.ORGANIZATION_ID AND sup.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND (msi.new_plan_id = -1) AND (msi.SIMULATION_SET_ID = -1) UNION ALL SELECT /*+ORDERED */ 'MSC_DEMANDS' SOURCE_TABLE, dem.ROWID ROW_ID, mfp2.DEMAND_ID transaction_id, dem.LAST_UPDATE_DATE, dem.LAST_UPDATED_BY, dem.CREATION_DATE, dem.CREATED_BY, dem.LAST_UPDATE_LOGIN, dem.INVENTORY_ITEM_ID, dem.ORGANIZATION_ID, msi.organization_code, to_number(NULL) PLAN_ORGANIZATION_ID, to_number(NULL) PLAN_INSTANCE_ID, mfp2.plan_id, mp.compile_designator, dem.USING_ASSEMBLY_DEMAND_DATE NEW_DUE_DATE, dem.OLD_DEMAND_DATE OLD_DUE_DATE, TO_DATE(NULL) NEW_START_DATE, dem.DISPOSITION_ID, msc_get_name.demand_order_number_new(dem.origination_type,dem.order_number,dem.plan_id,dem.disposition_id,dem.wip_entity_name, dem.orch_order_number,dem.schedule_designator_id,dem.SALES_ORDER_NUMBER,dem.demand_id) ORDER_NUMBER, TO_NUMBER(NULL) DISPOSITION_STATUS_TYPE, dem.origination_type ORDER_TYPE, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', dem.origination_type) from dual) ORDER_TYPE_TEXT, - NVL(dem.DAILY_DEMAND_RATE, dem.USING_REQUIREMENT_QUANTITY) QUANTITY_RATE, dem.OLD_DEMAND_QUANTITY OLD_ORDER_QUANTITY, TO_DATE(NULL) NEW_ORDER_DATE, DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2) FIRM_PLANNED_TYPE, dem.reschedule_flag RESCHEDULED_FLAG, TO_NUMBER(NULL) IMPLEMENTED_QUANTITY, TO_DATE(NULL) LAST_UNIT_COMPLETION_DATE, TO_DATE(NULL) NEW_DOCK_DATE, TO_NUMBER(NULL) QUANTITY_IN_PROCESS, dem.FIRM_QUANTITY, dem.FIRM_DATE, TO_NUMBER(NULL) LINE_ID, NULL IMPLEMENT_DEMAND_CLASS, msi.item_name ITEM_SEGMENTS, dem.implement_date, TO_NUMBER(NULL) IMPLEMENT_QUANTITY_RATE, dem.implement_firm, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, TO_CHAR(NULL) IMPLEMENT_WIP_CLASS_CODE, NULL IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, TO_NUMBER(NULL) IMPLEMENT_STATUS_CODE, TO_NUMBER(NULL) IMPLEMENT_LOCATION_ID, dem.release_status, TO_NUMBER(NULL) IMPLEMENT_AS, NULL IMPLEMENT_AS_TEXT, msi.PLANNER_CODE, dem.USING_ASSEMBLY_ITEM_ID, msi.MRP_PLANNING_CODE, NULL REPETITIVE_TYPE, msi.BUILD_IN_WIP_FLAG, msi.PURCHASING_ENABLED_FLAG, msi.PLANNING_MAKE_BUY_CODE, msi.BOM_ITEM_TYPE, msi.BASE_ITEM_ID, msi.WIP_SUPPLY_TYPE, dem.SOURCE_ORGANIZATION_ID, dem.SOURCE_ORG_instance_id SOURCE_SR_INSTANCE_ID, DECODE(dem.supply_id, NULL, DECODE(dem.origination_type,1006, DECODE(msc_get_name.order_type(dem.plan_id, dem.disposition_id), 2, NULL, msc_get_name.org_code(dem.source_organization_id)), 1030, DECODE(msc_get_name.order_type(dem.plan_id, dem.disposition_id), 2, NULL, msc_get_name.org_code(dem.source_organization_id)), 1001, DECODE(mp.plan_type, 5, NULL, msc_get_name.org_code(dem.source_organization_id)), msc_get_name.org_code(dem.source_organization_id)), NULL ) SOURCE_ORGANIZATION_CODE, NULL STATUS_CODE, 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, 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, dem.supplier_id VENDOR_ID, NULL SUPPLIER_NAME, dem.supplier_site_id VENDOR_SITE_ID, NULL SUPPLIER_SITE_CODE, dem.implement_org_id IMPLEMENT_SOURCE_ORG_ID, dem.implement_instance_id IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_SITE_ID, 2 IN_SOURCE_PLAN, to_number(NULL) SCHEDULE_COMPRESSION_DAYS, dem.project_id, dem.task_id, to_number(NULL) IMPLEMENT_PROJECT_ID, to_number(NULL) IMPLEMENT_TASK_ID, dem.applied, to_number(NULL) RELEASE_TIME_FENCE_CODE, to_number(NULL) IMPLEMENT_SCHEDULE_GROUP_ID, to_number(NULL) IMPLEMENT_BUILD_SEQUENCE, to_number(NULL) BUILD_SEQUENCE, to_number(NULL) SCHEDULE_GROUP_ID, NULL ALTERNATE_BOM_DESIGNATOR, NULL ALTERNATE_ROUTING_DESIGNATOR, to_number(NULL) PROCESS_SEQ_ID, NULL IMPLEMENT_ALTERNATE_BOM, NULL IMPLEMENT_ALTERNATE_ROUTING, NULL SCHEDULE_GROUP_NAME, to_number(NULL) IMPLEMENT_EMPLOYEE_ID, to_number(NULL) CFM_ROUTING_FLAG, msi.BUYER_NAME, dem.release_errors, dem.unit_number, NULL IMPLEMENT_UNIT_NUMBER, msi.description, msi.product_family_id, decode(msi.product_family_id, NULL, NULL, (select msc_get_name.item_name(msi.product_family_id, NULL,NULL) from dual)) PRODUCT_FAMILY_NAME, NULL BASE_ITEM_NAME, msi.uom_code, DECODE(dem.plan_id,-1,dem.order_priority,dem.demand_priority) DEMAND_PRIORITY, dem.override_demand_priority, decode(dem.origination_type, 1030, dem.promise_arrival_date, dem.promise_date) PROMISE_DATE, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 2, dem.request_date, null), dem.request_date) REQUEST_DATE, dem.customer_id, DECODE(dem.customer_id, NULL, NULL, (select msc_get_name.customer(dem.customer_id) from dual)) CUSTOMER_NAME, 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.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, dem.LOT_NUMBER, dem.sub_inventory_code SUBINVENTORY_CODE, NULL WIP_STATUS_CODE, NULL WIP_STATUS_TEXT, dem.dmd_satisfied_date, to_date(NULL) NEED_BY_DATE, decode(dem.schedule_designator_id, NULL, NULL, (select msc_get_name.designator(dem.schedule_designator_id, null, dem.plan_id) from dual)) DESIGNATOR_NAME, decode(dem.origination_type, 1029, nvl(dem.selling_price, msi.list_price * (1- nvl(msi.average_discount, 0)/100)), 1030, nvl(dem.selling_price, msi.list_price* (1- nvl(msi.average_discount, 0)/100)), 1008, nvl(dem.selling_price, msi.list_price* (1- nvl(msi.average_discount, 0)/100)), dem.selling_price) SELLING_PRICE, dem.demand_class, dem.probability, dem.planned_ship_date SHIP_DATE, -dem.using_requirement_quantity QUANTITY, DECODE(dem.origination_type,1001,NULL,1004,NULL,1016,NULL,1017,NULL,1018,NULL, 1019,NULL,1020,NULL,1021,NULL,1023,NULL,1025,NULL,1026,NULL,1028,NULL,1022,NULL, decode( (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) SOURCE_DMD_PRIORITY, to_number(NULL) RESCHEDULE_DAYS, to_date(NULL) OLD_NEED_BY_DATE, 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, dem.ship_method, dem.unmet_quantity, DECODE(dem.origination_type, 1029, to_number(NULL), 1008, to_number(NULL), dem.using_requirement_quantity+nvl(dem.completed_quantity,0)) ORIGINAL_QUANTITY, to_date(NULL) ORIGINAL_NEED_BY_DATE, to_date(NULL) Earliest_start_date, to_date(NULL) Consumption_Start_Date, NULL Contributes_Overload, NULL Contributes_dmd_lateness, NULL Shared_Supply, NULL Uses_Order_Modifier, NULL Pegged_to_Firm, NULL Material_Avail_Date, NULL Latest_Start_Date, dem.record_source, to_number(NULL) START_QUANTITY, dem.expiration_date, (select msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE',msi.mrp_planning_code) from dual) MRP_PLANNING_CODE_TEXT, dem.original_org_id, dem.original_inst_id, 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.SCHEDULE_ARRIVAL_DATE, decode( dem.order_date_type_code, 1, dem.latest_acceptable_ship_date, 2, dem.latest_acceptable_arrival_date , NULL) latest_acceptable_date, dem.PLANNED_ARRIVAL_DATE, to_number(NULL) SHIPMENT_ID, dem.SHIP_CALENDAR, NULL RECEIVING_CALENDAR, NULL INTRANSIT_CALENDAR, dem.intransit_lead_time, to_date(NULL) IMPLEMENT_DOCK_DATE, dem.implement_ship_date, dem.implement_arrival_date, decode(dem.origination_type, 1030, decode(dem.order_date_type_code, 1, dem.request_date, null),dem.request_ship_date) REQUEST_SHIP_DATE, dem.promise_ship_date, dem.days_late LATE_DAYS, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, 'MSC_DEMANDS' SOURCE_TABLE2, nvl(dem.schedule_ship_date, dem.USING_ASSEMBLY_DEMAND_DATE) SCHEDULE_SHIP_DATE, DECODE(mp.plan_type, 5, DECODE(dem.origination_type,1001, msc_get_name.org_code(dem.source_organization_id), 1024, msc_get_name.org_code(dem.source_organization_id), 1030, DECODE(dem.demand_source_type, 8, msc_get_name.org_code(dem.source_organization_id), NULL), NULL),NULL) DEST_ORG_CODE, dem.quantity_by_due_date*NVL(dem.probability,1) QTY_BY_DUE_DATE, dem.ship_set_name, dem.arrival_set_name, DECODE(mp.plan_type, 5, dem.source_organization_id,to_number(NULL)) DEST_ORG_ID, DECODE(mp.plan_type, 5, dem.source_org_instance_id,to_number(NULL)) DEST_INST_ID, to_number(NULL) IMPLEMENT_DEST_ORG_ID, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, DECODE(dem.zone_id, NULL,NULL, (select msc_get_name.get_zone_name(dem.zone_id) from dual)) ZONE, to_date(NULL) REQUESTED_COMPLETION_DATE, NULL LOTS_EXIST, NULL IMPLEMENT_SHIP_METHOD, to_date(NULL) ACTUAL_START_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, dem.schedule_designator_id, dem.sales_order_line_id, dem.ship_set_id, dem.arrival_set_id, to_date(NULL) FIRM_START_DATE, to_number(NULL) BILL_SEQUENCE_ID, to_number(NULL) ROUTING_SEQUENCE_ID, NULL COMMENTS, mfp2.allocated_quantity, mfp2.pegging_id, mfp2.end_pegging_id, -1234 up_level_demand_id, mfp2.transaction_id up_level_transaction_id, -1234 up_level_organization_id, -1234 up_level_inventory_item_id, -1234 up_level_pegging_id, -1234 up_level_prev_pegging_id, -1234 up_level_end_pegging_id, dem.load_type, msi.plan_id base_plan_id, msi.rounding_control_type, to_date(NULL) OLD_DOCK_DATE, NULL plan_cutoff_date, NULL plan_start_date, dem.reserved_quantity, TO_CHAR(NULL) CTB_FLAG, to_number(NULL) CTB_COMP_AVAIL_PERCENT, to_number(NULL) RTB_ORDER_QTY_PERCENT, to_date(NULL) CTB_EXPECTED_DATE, to_number(NULL) CTB_PRIORITY, dem.revised_dmd_date, dem.revised_dmd_priority, nvl(dem.ship_method, (select msc_get_name.get_ship_method(dem.carrier_id, dem.mode_of_transport, dem.service_level) from dual)) ship_method_text, dem.ORIG_FIRM_DATE, dem.ORIG_FIRM_QUANTITY, dem.SO_LINE_NUM, decode(dem.origination_type, 1030, dem.sales_order_number, dem.ORCH_ORDER_NUMBER) ORCH_ORDER_NUMBER, decode(dem.origination_type, 1030, nvl(dem.ORCH_ORDER_LINE_NUMBER, dem.SO_LINE_NUM), 1082, dem.SO_LINE_NUM, dem.ORCH_ORDER_LINE_NUMBER) ORCH_ORDER_LINE_NUMBER, dem.FULFILLMENT_LINE_NUM, mfp2.PEGGING_TYPE, NULL BMT_FLAG, NULL DROP_SHIP_DEST_TYPE, MSC_SPUI_COMMON.release_action ('MSC_DEMANDS',dem.plan_id,dem.ORGANIZATION_ID,dem.INVENTORY_ITEM_ID,dem.origination_type,dem.DEMAND_ID,msi.PURCHASING_ENABLED_FLAG,nvl(dem.reschedule_flag,2),0,null,msi.BUILD_IN_WIP_FLAG,dem.SOURCE_ORGANIZATION_ID,ABS(dem.USING_REQUIREMENT_QUANTITY),dem.FIRM_QUANTITY,dem.release_status,msi.wip_supply_type,msi.BOM_ITEM_TYPE,msi.PLANNING_MAKE_BUY_CODE,null,dem.original_quantity,null,dem.reserved_quantity,NULL,msi.PLANNER_CODE,DECODE(dem.org_firm_flag, 1, 1, 3, 2, 2),dem.applied,to_number(null),msi.back_to_back_flag,msi.in_source_plan,null,null,dem.release_errors) release_action, msi.back_to_back_flag, 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, 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, to_char(null) ITEM_STRUCTURE_NAME, to_char(null) WORK_DEFINITION, to_char(null) IMPLEMENT_ITEM_STRUCTURE, to_char(null) IMPLEMENT_WORK_DEFINITION, 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, decode(dem.completed_quantity, 0, to_number(null), dem.completed_quantity) QTY_COMPLETED, to_number(null) QTY_SCRAPPED, to_number(null) EXPECTED_SCRAP_QTY, to_number(null) FIRM_START_QUANTITY, (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, dem.op_seq_num OPERATION_SEQ_NUM, 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, to_number(null) total_output_quantity, to_date(null) last_op_completion_date, to_number(null) work_method_code, to_char(null) process_name, to_char(null) BATCH_UOM, to_number(NULL) WORK_ORDER_SUB_TYPE, msi.hard_pegging_level, dem.GLOBAL_ATTRIBUTE_NUMBER11, dem.GLOBAL_ATTRIBUTE_NUMBER12, dem.GLOBAL_ATTRIBUTE_NUMBER13, dem.GLOBAL_ATTRIBUTE_NUMBER14, dem.GLOBAL_ATTRIBUTE_NUMBER15, dem.GLOBAL_ATTRIBUTE_NUMBER16, dem.GLOBAL_ATTRIBUTE_NUMBER17, dem.GLOBAL_ATTRIBUTE_NUMBER18, dem.GLOBAL_ATTRIBUTE_NUMBER19, dem.GLOBAL_ATTRIBUTE_NUMBER20, dem.GLOBAL_ATTRIBUTE_NUMBER21, dem.GLOBAL_ATTRIBUTE_NUMBER22, dem.GLOBAL_ATTRIBUTE_NUMBER23, dem.GLOBAL_ATTRIBUTE_NUMBER24, dem.GLOBAL_ATTRIBUTE_NUMBER25, dem.GLOBAL_ATTRIBUTE_NUMBER26, dem.GLOBAL_ATTRIBUTE_NUMBER27, dem.GLOBAL_ATTRIBUTE_NUMBER28, dem.GLOBAL_ATTRIBUTE_NUMBER29, dem.GLOBAL_ATTRIBUTE_NUMBER30, dem.GLOBAL_ATTRIBUTE_NUMBER31, dem.GLOBAL_ATTRIBUTE_NUMBER32, dem.GLOBAL_ATTRIBUTE_NUMBER33, dem.GLOBAL_ATTRIBUTE_NUMBER34, dem.GLOBAL_ATTRIBUTE_NUMBER35, dem.GLOBAL_ATTRIBUTE_NUMBER36, dem.GLOBAL_ATTRIBUTE_NUMBER37, dem.GLOBAL_ATTRIBUTE_NUMBER38, dem.GLOBAL_ATTRIBUTE_NUMBER39, dem.GLOBAL_ATTRIBUTE_NUMBER40, 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, decode(msi.PLANNER_CODE, NULL, NULL, (select msc_get_name.get_planner_desc(msi.PLANNER_CODE) from dual)) PLANNER_DESCRIPTION, dem.asset_number, msi.segment_id, decode(msi.segment_id, NULL, NULL, (select msc_get_name.segment_name(msi.segment_id) from dual)) SEGMENT_NAME, mfp2.net_seq_num, NVL(dem.original_demand_id,dem.demand_id) original_transaction_id, to_date(null) HOLD_DATE, to_number(null) order_status, to_char(null) implement_location_code, dem.child_organization_id, decode(dem.child_organization_id, NULL, NULL, (select msc_get_name.org_code(dem.child_organization_id) from dual)) child_organization_code, to_char(null) original_subinventory_code, dem.ATTRIBUTE_ROW_ID, to_number(null) fg_order_type, to_date(null) maturity_date, to_date(null) constrained_start_date, to_number(null) cumulative_yield, to_date(null) mtq_supply_date FROM msc_full_pegging mfp2, msc_plan_definitions mp, msc_demands dem, msc_system_items msi WHERE mfp2.plan_id = mp.plan_id AND mfp2.plan_id = dem.plan_id AND mfp2.demand_id = dem.demand_id AND mfp2.pegging_id = mfp2.end_pegging_id AND dem.base_plan_id = msi.plan_id AND dem.ORGANIZATION_ID = msi.ORGANIZATION_ID AND dem.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND (msi.new_plan_id = -1) AND (msi.SIMULATION_SET_ID = -1) UNION ALL SELECT /*+ORDERED */ 'MSC_DEMANDS' SOURCE_TABLE, NULL ROW_ID, mfp2.demand_id transaction_id, to_date(NULL) LAST_UPDATE_DATE, to_char(NULL) LAST_UPDATED_BY, to_date(NULL) CREATION_DATE, to_char(NULL) CREATED_BY, to_char(NULL) LAST_UPDATE_LOGIN, mfp2.INVENTORY_ITEM_ID, mfp2.ORGANIZATION_ID, msi.organization_code, to_number(NULL) PLAN_ORGANIZATION_ID, to_number(NULL) PLAN_INSTANCE_ID, mfp2.plan_id, mp.compile_designator, to_date(NULL) NEW_DUE_DATE, to_date(NULL) OLD_DUE_DATE, TO_DATE(NULL) NEW_START_DATE, to_number(NULL) DISPOSITION_ID, TO_CHAR(NULL) ORDER_NUMBER, TO_NUMBER(NULL) DISPOSITION_STATUS_TYPE, mfp2.demand_id ORDER_TYPE, (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', mfp2.demand_id) from dual) ORDER_TYPE_TEXT, to_number(NULL) QUANTITY_RATE, to_number(NULL) OLD_ORDER_QUANTITY, TO_DATE(NULL) NEW_ORDER_DATE, to_number(NULL) FIRM_PLANNED_TYPE, to_number(NULL) RESCHEDULED_FLAG, TO_NUMBER(NULL) IMPLEMENTED_QUANTITY, TO_DATE(NULL) LAST_UNIT_COMPLETION_DATE, TO_DATE(NULL) NEW_DOCK_DATE, TO_NUMBER(NULL) QUANTITY_IN_PROCESS, TO_NUMBER(NULL) FIRM_QUANTITY, to_date(NULL) FIRM_DATE, TO_NUMBER(NULL) LINE_ID, NULL IMPLEMENT_DEMAND_CLASS, msi.item_name ITEM_SEGMENTS, TO_DATE(NULL) IMPLEMENT_DATE, TO_NUMBER(NULL) IMPLEMENT_QUANTITY_RATE, TO_NUMBER(NULL) IMPLEMENT_FIRM, TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS, TO_CHAR(NULL) IMPLEMENT_WIP_CLASS_CODE, NULL IMPLEMENT_JOB_NAME, TO_NUMBER(NULL) IMPLEMENT_LINE_ID, TO_NUMBER(NULL) IMPLEMENT_STATUS_CODE, TO_NUMBER(NULL) IMPLEMENT_LOCATION_ID, TO_NUMBER(NULL) RELEASE_STATUS, TO_NUMBER(NULL) IMPLEMENT_AS, NULL IMPLEMENT_AS_TEXT, msi.PLANNER_CODE, TO_NUMBER(NULL) USING_ASSEMBLY_ITEM_ID, msi.MRP_PLANNING_CODE, null REPETITIVE_TYPE, msi.BUILD_IN_WIP_FLAG, msi.PURCHASING_ENABLED_FLAG, msi.PLANNING_MAKE_BUY_CODE, msi.BOM_ITEM_TYPE, msi.BASE_ITEM_ID, msi.WIP_SUPPLY_TYPE, to_number(NULL) SOURCE_ORGANIZATION_ID, TO_NUMBER(NULL) SOURCE_SR_INSTANCE_ID, TO_CHAR(NULL) SOURCE_ORGANIZATION_CODE, NULL STATUS_CODE, TO_CHAR(NULL) USING_ASSEMBLY_SEGMENTS, NULL SOURCE_VENDOR_NAME, NULL SOURCE_VENDOR_SITE_CODE, TO_NUMBER(NULL) VENDOR_ID, NULL SUPPLIER_NAME, TO_NUMBER(NULL) VENDOR_SITE_ID, NULL SUPPLIER_SITE_CODE, TO_NUMBER(NULL) IMPLEMENT_SOURCE_ORG_ID, TO_NUMBER(NULL) IMPLEMENT_SR_INSTANCE_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_ID, TO_NUMBER(NULL) IMPLEMENT_VENDOR_SITE_ID, 2 IN_SOURCE_PLAN, to_number(NULL) SCHEDULE_COMPRESSION_DAYS, TO_NUMBER(NULL) PROJECT_ID, TO_NUMBER(NULL) TASK_ID, to_number(NULL) IMPLEMENT_PROJECT_ID, to_number(NULL) IMPLEMENT_TASK_ID, NULL APPLIED, to_number(NULL) RELEASE_TIME_FENCE_CODE, to_number(NULL) IMPLEMENT_SCHEDULE_GROUP_ID, to_number(NULL) IMPLEMENT_BUILD_SEQUENCE, to_number(NULL) BUILD_SEQUENCE, to_number(NULL) SCHEDULE_GROUP_ID, NULL ALTERNATE_BOM_DESIGNATOR, NULL ALTERNATE_ROUTING_DESIGNATOR, to_number(NULL) PROCESS_SEQ_ID, NULL IMPLEMENT_ALTERNATE_BOM, NULL IMPLEMENT_ALTERNATE_ROUTING, NULL SCHEDULE_GROUP_NAME, to_number(NULL) IMPLEMENT_EMPLOYEE_ID, to_number(NULL) CFM_ROUTING_FLAG, msi.buyer_name, NULL RELEASE_ERRORS, NULL UNIT_NUMBER, NULL IMPLEMENT_UNIT_NUMBER, msi.description, msi.product_family_id, decode(msi.product_family_id, NULL, NULL, (select msc_get_name.item_name(msi.product_family_id, NULL,NULL) from dual)) PRODUCT_FAMILY_NAME, NULL BASE_ITEM_NAME, msi.uom_code, NULL DEMAND_PRIORITY, NULL OVERRIDE_DEMAND_PRIORITY, NULL PROMISE_DATE, NULL REQUEST_DATE, NULL CUSTOMER_ID, NULL CUSTOMER_NAME, NULL CUSTOMER_SITE_ID, NULL CUSTOMER_SITE_NAME, NULL SHIP_TO_SITE_ID, NULL SHIP_TO_SITE_NAME, NULL LOT_NUMBER, NULL SUBINVENTORY_CODE, NULL WIP_STATUS_CODE, NULL WIP_STATUS_TEXT, NULL DMD_SATISFIED_DATE, to_date(NULL) NEED_BY_DATE, NULL DESIGNATOR_NAME, NULL SELLING_PRICE, NULL DEMAND_CLASS, NULL PROBABILITY, NULL SHIP_DATE, - mfp2.demand_quantity QUANTITY, NULL BUCKET_TYPE, NULL SOURCE_DMD_PRIORITY, to_number(NULL) RESCHEDULE_DAYS, to_date(NULL) OLD_NEED_BY_DATE, NULL ORIGINAL_ITEM_ID, NULL ORIGINAL_ITEM_NAME, NULL ORIGINAL_ITEM_QTY, NULL SHIP_METHOD, NULL UNMET_QUANTITY, NULL ORIGINAL_QUANTITY, to_date(NULL) ORIGINAL_NEED_BY_DATE, to_date(NULL) Earliest_start_date, to_date(NULL) Consumption_Start_Date, NULL Contributes_Overload, NULL Contributes_dmd_lateness, NULL Shared_Supply, NULL Uses_Order_Modifier, NULL Pegged_to_Firm, NULL Material_Avail_Date, NULL Latest_Start_Date, NULL RECORD_SOURCE, to_number(NULL) START_QUANTITY, NULL EXPIRATION_DATE, (select msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE',msi.mrp_planning_code) from dual) MRP_PLANNING_CODE_TEXT, NULL ORIGINAL_ORG_ID, NULL ORIGINAL_INST_ID, NULL ORDER_DATE_TYPE_CODE, NULL ORDER_DATE_TYPE_TEXT, NULL SCHEDULE_ARRIVAL_DATE, NULL LATEST_ACCEPTABLE_DATE, NULL PLANNED_ARRIVAL_DATE, NULL SHIPMENT_ID, NULL SHIP_CALENDAR, NULL RECEIVING_CALENDAR, NULL INTRANSIT_CALENDAR, NULL INTRANSIT_LEAD_TIME, to_date(NULL) IMPLEMENT_DOCK_DATE, NULL IMPLEMENT_SHIP_DATE, NULL IMPLEMENT_ARRIVAL_DATE, NULL REQUEST_SHIP_DATE, NULL PROMISE_SHIP_DATE, NULL late_days, to_number(NULL) SUBSTITUTE_COMPONENT_RANK, 'MSC_DEMANDS' SOURCE_TABLE2, NULL SCHEDULE_SHIP_DATE, NULL DEST_ORG_CODE, NULL QTY_BY_DUE_DATE, NULL SHIP_SET_NAME, NULL ARRIVAL_SET_NAME, NULL DEST_ORG_ID, NULL DEST_INST_ID, to_number(NULL) IMPLEMENT_DEST_ORG_ID, to_number(NULL) IMPLEMENT_DEST_INST_ID, NULL IMPLEMENT_DEST_ORG_CODE, NULL ZONE, to_date(NULL) REQUESTED_COMPLETION_DATE, NULL LOTS_EXIST, NULL IMPLEMENT_SHIP_METHOD, to_date(NULL) ACTUAL_START_DATE, to_date(NULL) IMPLEMENT_DUE_DATE, NULL SCHEDULE_DESIGNATOR_ID, NULL SALES_ORDER_LINE_ID, NULL SHIP_SET_ID, NULL ARRIVAL_SET_ID, to_date(NULL) FIRM_START_DATE, to_number(NULL) BILL_SEQUENCE_ID, to_number(NULL) ROUTING_SEQUENCE_ID, NULL COMMENTS, mfp2.allocated_quantity, mfp2.pegging_id, mfp2.end_pegging_id, -1234 up_level_demand_id, mfp2.transaction_id up_level_transaction_id, -1234 up_level_organization_id, -1234 up_level_inventory_item_id, -1234 up_level_pegging_id, -1234 up_level_prev_pegging_id, -1234 up_level_end_pegging_id, to_number(NULL) load_type, msi.plan_id base_plan_id, msi.rounding_control_type rounding_control_type, to_date(NULL) OLD_DOCK_DATE, null plan_cutoff_date, null plan_start_date, to_number(NULL) reserved_quantity, TO_CHAR(NULL) CTB_FLAG, to_number(NULL) CTB_COMP_AVAIL_PERCENT, to_number(NULL) RTB_ORDER_QTY_PERCENT, to_date(NULL) CTB_EXPECTED_DATE, to_number(NULL) CTB_PRIORITY, to_date(NULL) revised_dmd_date, to_number(NULL) revised_dmd_priority, NULL ship_method_text, to_date(NULL) ORIG_FIRM_DATE, to_number(NULL) ORIG_FIRM_QUANTITY, NULL SO_LINE_NUM, to_char(null) ORCH_ORDER_NUMBER, to_char(null) ORCH_ORDER_LINE_NUMBER, to_number(null) FULFILLMENT_LINE_NUM, mfp2.PEGGING_TYPE, NULL BMT_FLAG, NULL DROP_SHIP_DEST_TYPE, MSC_SPUI_COMMON.release_action ('MSC_DEMANDS',mfp2.plan_id,mfp2.ORGANIZATION_ID,mfp2.INVENTORY_ITEM_ID,mfp2.demand_id,mfp2.demand_id,msi.PURCHASING_ENABLED_FLAG,2,0,null,msi.BUILD_IN_WIP_FLAG,null,mfp2.demand_quantity,null,null,msi.wip_supply_type,msi.BOM_ITEM_TYPE, msi.PLANNING_MAKE_BUY_CODE,null,null,null,null,NULL,msi.PLANNER_CODE,to_number(NULL),to_number(NULL),to_number(null),msi.back_to_back_flag,msi.in_source_plan,null,null,null) release_action, msi.back_to_back_flag, NULL DEMAND_CLASS_CODE, to_number(null) NET_SUPPLY_QTY_OVERRIDE, to_number(null) IMPLEMENT_BILL_SEQUENCE_ID, to_number(null) IMPLEMENT_ROUTING_SEQUENCE_ID, to_number(null) CARRIER_ID, to_number(null) MODE_OF_TRANSPORT, to_number(null) 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, to_char(null) CUSTOMER_PO_NUMBER, to_char(null) ITEM_STRUCTURE_NAME, to_char(null) WORK_DEFINITION, to_char(null) IMPLEMENT_ITEM_STRUCTURE, to_char(null) IMPLEMENT_WORK_DEFINITION, to_number(null) 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, to_number(null) QTY_COMPLETED, to_number(null) QTY_SCRAPPED, to_number(null) EXPECTED_SCRAP_QTY, to_number(null) FIRM_START_QUANTITY, (select msc_get_name.get_timezone_name(mfp2.organization_id) from dual) TIMEZONE_NAME, (select msc_get_name.get_timezone_code(mfp2.organization_id) from dual) TIMEZONE_CODE, TO_CHAR(NULL) SOURCE_TIMEZONE_NAME, TO_CHAR(NULL) SOURCE_TIMEZONE_CODE, TO_CHAR(NULL) DESTINATION_TIMEZONE_NAME, TO_CHAR(NULL) DESTINATION_TIMEZONE_CODE, to_number(null) OPERATION_SEQ_NUM, 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, to_number(null) total_output_quantity, to_date(null) last_op_completion_date, to_number(null) work_method_code, to_char(null) process_name, to_char(null) BATCH_UOM, to_number(NULL) WORK_ORDER_SUB_TYPE, msi.hard_pegging_level, NULL GLOBAL_ATTRIBUTE_NUMBER11, NULL GLOBAL_ATTRIBUTE_NUMBER12, NULL GLOBAL_ATTRIBUTE_NUMBER13, NULL GLOBAL_ATTRIBUTE_NUMBER14, NULL GLOBAL_ATTRIBUTE_NUMBER15, NULL GLOBAL_ATTRIBUTE_NUMBER16, NULL GLOBAL_ATTRIBUTE_NUMBER17, NULL GLOBAL_ATTRIBUTE_NUMBER18, NULL GLOBAL_ATTRIBUTE_NUMBER19, NULL GLOBAL_ATTRIBUTE_NUMBER20, NULL GLOBAL_ATTRIBUTE_NUMBER21, NULL GLOBAL_ATTRIBUTE_NUMBER22, NULL GLOBAL_ATTRIBUTE_NUMBER23, NULL GLOBAL_ATTRIBUTE_NUMBER24, NULL GLOBAL_ATTRIBUTE_NUMBER25, NULL GLOBAL_ATTRIBUTE_NUMBER26, NULL GLOBAL_ATTRIBUTE_NUMBER27, NULL GLOBAL_ATTRIBUTE_NUMBER28, NULL GLOBAL_ATTRIBUTE_NUMBER29, NULL GLOBAL_ATTRIBUTE_NUMBER30, NULL GLOBAL_ATTRIBUTE_NUMBER31, NULL GLOBAL_ATTRIBUTE_NUMBER32, NULL GLOBAL_ATTRIBUTE_NUMBER33, NULL GLOBAL_ATTRIBUTE_NUMBER34, NULL GLOBAL_ATTRIBUTE_NUMBER35, NULL GLOBAL_ATTRIBUTE_NUMBER36, NULL GLOBAL_ATTRIBUTE_NUMBER37, NULL GLOBAL_ATTRIBUTE_NUMBER38, NULL GLOBAL_ATTRIBUTE_NUMBER39, NULL GLOBAL_ATTRIBUTE_NUMBER40, to_char(null) implement_source_org, to_char(null) IMPLEMENT_SUPPLIER, to_char(null) IMPLEMENT_SUPPLIER_SITE, (select MSC_SPUI_COMMON.GET_ORG_CURRENCY_CODE(msi.ORGANIZATION_ID) from dual) ORG_CURRENCY_CODE, to_number(null) QTY_REMAINING, decode(msi.PLANNER_CODE, NULL, NULL, (select msc_get_name.get_planner_desc(msi.PLANNER_CODE) from dual)) PLANNER_DESCRIPTION, to_char(null) ASSET_NUMBER, msi.segment_id, decode(msi.segment_id, NULL, NULL, (select msc_get_name.segment_name(msi.segment_id) from dual)) SEGMENT_NAME, mfp2.net_seq_num, to_number(null) original_transaction_id, to_date(null) HOLD_DATE, to_number(null) order_status, to_char(null) implement_location_code, to_number(null) child_organization_id, to_char(null) child_organization_code, to_char(null) original_subinventory_code, to_number(null) Attribute_Row_Id, to_number(null) fg_order_type, to_date(null) maturity_date, to_date(null) constrained_start_date, to_number(null) cumulative_yield, to_date(null) mtq_supply_date FROM msc_full_pegging mfp2, msc_plan_definitions mp, msc_system_items msi WHERE mfp2.demand_id IN (-1,-2,-3) AND mfp2.pegging_id = mfp2.end_pegging_id AND mfp2.plan_id = mp.plan_id AND msi.plan_id = NVL(mp.base_plan_id,mp.plan_id) AND mfp2.organization_id = msi.organization_id AND mfp2.inventory_item_id = msi.inventory_item_id AND (msi.new_plan_id = -1) AND (msi.SIMULATION_SET_ID =-1)