eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_X_EXCEPTION_DETAILS_V

Source

View Text - Preformatted


SELECT /*+ FIRST_ROWS */ mxed.EXCEPTION_DETAIL_ID ,2 ,-1 ,mxed.COMPANY_SITE_ID ,mxed.SR_INSTANCE_ID ,mxed.INVENTORY_ITEM_ID ,mxed.EXCEPTION_TYPE ,mxed.LAST_UPDATE_DATE ,mxed.LAST_UPDATED_BY ,mxed.CREATION_DATE ,mxed.CREATED_BY ,mxed.LAST_UPDATE_LOGIN ,mxed.COMPANY_SITE_NAME ,to_number(null) ,to_number(null) ,to_char(null) ,mxed.ITEM_NAME ,to_char(null) ITEM_DESCRIPTION ,to_char(null) BUYER_NAME ,to_char(null) PLANNER_CODE ,EXCEPTION_TYPE_NAME ,to_number(null) ,to_number(null) ,to_char(null) ,to_char(null) PROJECT_NUMBER ,to_char(null) TASK_NUMBER ,to_char(null) PLANNING_GROUP ,to_char(null) TO_PROJECT_NUMBER ,to_char(null) TO_TASK_NUMBER ,to_date(null) DUE_DATE ,to_date(null) FROM_DATE ,to_date(null) TO_DATE ,to_number(null) DAYS_COMPRESSED ,to_number(null) QUANTITY ,to_char(null) LOT_NUMBER ,to_char(null) ORDER_NUMBER ,to_char(null) SUPPLY_TYPE ,to_char(null) END_ITEM_SEGMENTS ,to_char(null) PLANNED_INVENTORY_POINT ,to_char(null) END_ORDER_NUMBER ,to_number(null) TRANSACTION_ID ,to_number(null) DEMAND_ID ,to_number(null) DEPARTMENT_ID ,to_number(null) RESOURCE_ID ,to_char(null) DEPARTMENT_LINE_CODE ,to_char(null) RESOURCE_CODE ,to_number(null) RESOURCE_TYPE ,to_char(null) RESOURCE_TYPE_CODE ,to_number(null) UTILIZATION_RATE ,to_char(mxed.SUPPLIER_ID) ,mxed.SUPPLIER_NAME ,to_char(mxed.SUPPLIER_SITE_ID) ,mxed.SUPPLIER_SITE_NAME ,mxed.CUSTOMER_ID ,mxed.CUSTOMER_NAME ,mxed.CUSTOMER_SITE_ID ,mxed.CUSTOMER_SITE_NAME ,to_number(null) ORDER_PRIORITY ,to_date(null) DMD_SATISFIED_DATE ,to_char(null) SUBSTITUTE_COMPONENT ,to_char(null) ALTERNATE_ROUTING_DESIGNATOR ,to_char(null) ALTERNATE_BOM_DESIGNATOR ,to_number(null) SOURCE_ORGANIZATION_ID ,to_number(null) SOURCE_ORG_INSTANCE_ID ,to_char(null) SOURCE_ORGANIZATION_CODE ,to_date(null) REPLENISHMENT_DATE ,to_number(null) END_PEGGING_ID ,to_number(null) DEMAND_QUANTITY ,to_date(null) OLD_DUE_DATE ,to_char(null) ORDER_TYPE ,to_number(null) ORDER_TYPE_ID ,to_number(null) BATCHABLE_FLAG ,to_number(null) MIN_CAPACITY ,to_number(null) MAX_CAPACITY ,to_number(null) BATCH_NUMBER ,to_number(null) REQUIRED_CAPACITY ,to_number(null) QUANTITY_BY_DUE_DATE ,to_number(null) RESOURCE_OVER_UTIL_COST ,to_number(null) ALLOCATED_PERCENTAGE ,to_number(null) ACTUAL_PERCENTAGE ,to_number(null) PERCENT_VARIANCE ,2 ACTION_TAKEN ,mxed.ROWID ROW_ID ,decode(mxed.EXCEPTION_TYPE, 1, abs(mxed.date2-mxed.date1), 2, abs(mxed.date2-mxed.date1), 13, number3, 50, number3, 51, number3, to_number(null)) DAYS_LATE ,to_number(null) SUBSTITUTE_ITEM_ID ,to_char(null) SUBSTITUTE_ITEM_NAME ,to_number(null) SUBSTITUTE_ORG_ID ,to_char(null) SUBSTITUTE_ORG_CODE ,to_number(null) SUBSTITUTE_QTY ,to_number(null) PREFERENCE ,to_number(null) ORIGINATION_TYPE_ID ,to_char(null) ORIGINATION_TYPE ,to_number(null) DEMAND_DATE_QUANTITY ,to_char(null) DEMAND_CLASS ,to_number(null) OPERATION_SEQ_NUM ,to_number(null) RESOURCE_SEQ_NUM ,to_char(null) FIRM_TYPE ,to_number(null) FIRM_PLANNED_TYPE ,to_date(null) MIN_START_TIME ,to_number(null) MIN_LEAD_TIME ,to_date(null) NEW_DOCK_DATE ,to_number(null) AVAILABLE_CAPACITY ,to_number(null) QTY_MISMATCH ,to_number(null) ACTUAL_DURATION ,to_char(null) SUPPLY_ORGANIZATION_CODE ,to_number(null) SUPPLY_ORGANIZATION_ID ,to_number(null) SUPPLY_SR_INSTANCE_ID ,to_char(null) SUPPLY_ITEM_SEGMENTS ,to_number(null) SUPPLY_INVENTORY_ITEM_ID ,to_char(null) SUPPLY_PLANNER_CODE ,to_char(null) SUPPLY_ORDER_TYPE ,to_number(null) SUPPLY_ORDER_TYPE_ID ,to_number(null) SUPPLY_SUPPLIER_ID ,to_char(null) SUPPLY_SUPPLIER_NAME ,to_number(null) SUPPLY_SUPPLIER_SITE_ID ,to_char(null) SUPPLY_SUPPLIER_SITE ,to_char(null) SUPPLY_SOURCE_ORGA_CODE ,to_number(null) SUPPLY_SOURCE_ORG_ID ,to_number(null) SUPPLY_SOURCE_SR_INSTANCE_ID ,to_char(null) SUPPLY_PLANNING_GROUP ,to_number(null) SUPPLY_PROJECT_ID ,to_char(null) SUPPLY_PROJECT_NUMBER ,to_number(null) SUPPLY_TASK_ID ,to_char(null) SUPPLY_TASK_NUMBER ,to_number(null) SALES_ORDER_LINE_PRICE ,to_number(null) DUE_DATE_QTY_PCT ,to_number(null) COMPRESSION_PCT ,to_number(null) CONSTRAINT_PCT ,to_number(null) DAYS_EARLY_BEFORE_LADATE ,to_number(null) DAYS_EARLY_ARRIVAL ,to_number(null) DAYS_PAST ,to_number(null) DAYS_LATE_BEYOND_LADATE ,to_number(null) DAYS_LATE_ARRIVAL ,to_number(null) EXCESS_DURATION ,to_number(null) RESCHEDULE_IN_DAYS ,to_number(null) RESCHEDULE_OUT_DAYS ,to_number(null) QTY_MISMATCH_PCT ,to_number(null) SS_QUANTITY ,to_number(null) SHORTAGE_DURATION ,to_date(null) JUST_DATE ,to_char(null) TO_PLANNING_GROUP ,to_number(null) DEST_ORGANIZATION_ID ,to_number(null) DEST_SR_INSTANCE_ID ,to_char(null) DEST_ORGANIZATION_CODE ,mxed.CUSTOMER_ITEM_NAME ,decode(mxed.EXCEPTION_TYPE, 1, mxed.ORDER_NUMBER, 3, mxed.ORDER_NUMBER, 7, mxed.ORDER_NUMBER, 11, mxed.ORDER_NUMBER, 23, mxed.ORDER_NUMBER, 27, mxed.ORDER_NUMBER, 33, mxed.ORDER_NUMBER, 34, mxed.ORDER_NUMBER, to_char(null)) CUSTOMER_PO ,decode(mxed.EXCEPTION_TYPE, 1,mxed.ORDER_CREATION_DATE1, 3, mxed.ORDER_CREATION_DATE1, 7, mxed.ORDER_CREATION_DATE1, 11, mxed.ORDER_CREATION_DATE1, 23, mxed.ORDER_CREATION_DATE1, 27, mxed.ORDER_CREATION_DATE1, 33, mxed.ORDER_CREATION_DATE1, 34, mxed.ORDER_CREATION_DATE1, to_date(null)) CUSTOMER_PO_CREATION_DATE ,decode(mxed.EXCEPTION_TYPE, 1, mxed.LINE_NUMBER, 3, mxed.LINE_NUMBER, 7, mxed.LINE_NUMBER, 11, mxed.LINE_NUMBER, 23, mxed.LINE_NUMBER, 27, mxed.LINE_NUMBER, 33, mxed.LINE_NUMBER, 34, mxed.LINE_NUMBER, to_char(null)) CUSTOMER_PO_LINE ,decode(mxed.EXCEPTION_TYPE, 1 ,mxed.DATE2, 3 ,mxed.DATE1, 7 ,mxed.DATE2, 11 ,mxed.DATE1, 23 ,mxed.DATE2, 27 ,mxed.DATE2, to_date(null)) CUSTOMER_PO_NEED_BY_DATE ,decode(mxed.EXCEPTION_TYPE, 1, mxed.NUMBER2, 3, mxed.NUMBER1, 7, mxed.NUMBER2, 11, mxed.NUMBER1, 23, mxed.NUMBER2, 27, mxed.NUMBER2, 33, mxed.NUMBER1, 34, mxed.NUMBER1, to_number(null)) CUSTOMER_PO_QUANTITY ,to_date(null) CUSTOMER_PO_RECEIPT_DATE ,decode(mxed.EXCEPTION_TYPE, 33, mxed.date1, to_date(null)) CUSTOMER_PO_CANCEL_DATE ,decode(mxed.EXCEPTION_TYPE, 34, mxed.date1, to_date(null)) CUSTOMER_PO_UPDATED_DATE ,decode(mxed.EXCEPTION_TYPE, 1,mxed.RELEASE_NUMBER, 3,mxed.RELEASE_NUMBER, 7,mxed.RELEASE_NUMBER, 11,mxed.RELEASE_NUMBER, 23,mxed.RELEASE_NUMBER, 27,mxed.RELEASE_NUMBER, to_char(null)) CUSTOMER_PO_RELEASE ,decode(mxed.EXCEPTION_TYPE, 23, abs(mxed.DATE2-mxed.DATE1), 24, abs(mxed.DATE2-mxed.DATE1), to_number(null)) DAYS_EARLY ,decode(mxed.EXCEPTION_TYPE, 3, SYSDATE-mxed.DATE1, 4, SYSDATE-mxed.DATE1, to_date(null)) DAYS_PAST_DUE ,decode(mxed.EXCEPTION_TYPE, 25, round(abs(mxed.number2-mxed.number1),6), 26, round(abs(mxed.number2-mxed.number1),6), 27, round(abs(mxed.number2-mxed.number1),6), 28, round(abs(mxed.number2-mxed.number1),6), 29, round(abs(mxed.number1+mxed.number2-mxed.item_max_qty),6), 30, round(abs(mxed.number1+mxed.number2-mxed.item_max_qty),6), to_number(null)) EXCESS_QUANTITY ,decode(mxed.exception_type, 25, round(abs(mxed.number2-mxed.number1)/mxed.number1 * 100, 6), 26, round(abs(mxed.number2-mxed.number1)/mxed.number1 * 100, 6), 27, round(abs(mxed.number2-mxed.number1)/mxed.number1 * 100, 6), 28, round(abs(mxed.number2-mxed.number1)/mxed.number1 * 100, 6), to_number(null)) EXCESS_QUANTITY_PCT ,decode(mxed.EXCEPTION_TYPE, 45, mxed.number3, 46, mxed.number3, TO_NUMBER(NULL)) INVENTORY_TURNS ,mxed.DATE2 PERIOD_END_DATE ,mxed.DATE1 PERIOD_START_DATE ,decode(mxed.EXCEPTION_TYPE, 2, mxed.ORDER_NUMBER, 4, mxed.ORDER_NUMBER, 8, mxed.ORDER_NUMBER, 13, mxed.ORDER_NUMBER, 14, mxed.ORDER_NUMBER, 24, mxed.ORDER_NUMBER, 28, mxed.ORDER_NUMBER, 31, mxed.ORDER_NUMBER, 49, mxed.ORDER_NUMBER, to_char(null)) PURCHASE_ORDER ,decode(mxed.EXCEPTION_TYPE, 2, mxed.ORDER_CREATION_DATE1, 4, mxed.ORDER_CREATION_DATE1, 8, mxed.ORDER_CREATION_DATE1, 13, mxed.ORDER_CREATION_DATE1, 14, mxed.ORDER_CREATION_DATE1, 24, mxed.ORDER_CREATION_DATE1, 28, mxed.ORDER_CREATION_DATE1, 31, mxed.ORDER_CREATION_DATE1, 49, mxed.ORDER_CREATION_DATE1, to_date(null)) PO_CREATION_DATE ,decode(mxed.EXCEPTION_TYPE, 2, mxed.DATE1, 4, mxed.DATE1, 8, mxed.DATE1, 13, mxed.DATE1, 14, mxed.DATE1, 24, mxed.DATE1, 28, mxed.DATE1, 31, mxed.DATE1, 49, mxed.DATE1, to_date(null)) PO_NEED_BY_DATE ,decode(mxed.EXCEPTION_TYPE, 49, mxed.DATE2, to_date(null)) PO_UPDATE_DATE ,decode(mxed.EXCEPTION_TYPE, 2, mxed.NUMBER1, 4, mxed.NUMBER2, 8, mxed.NUMBER1, 13, mxed.NUMBER1, 14, mxed.NUMBER1, 24, mxed.NUMBER1, 28, mxed.NUMBER1, 31, mxed.NUMBER1, 49, mxed.NUMBER1, to_number(null)) PO_QUANTITY ,decode(mxed.EXCEPTION_TYPE, 1,mxed.END_ORDER_NUMBER, 2,mxed.END_ORDER_NUMBER, 7,mxed.END_ORDER_NUMBER, 12,mxed.END_ORDER_NUMBER, 16,mxed.END_ORDER_NUMBER, 27,mxed.END_ORDER_NUMBER, to_char(null)) SALES_ORDER ,decode(mxed.EXCEPTION_TYPE, 1,mxed.END_ORDER_LINE_NUMBER, 2,mxed.END_ORDER_LINE_NUMBER, 7,mxed.END_ORDER_LINE_NUMBER, 12,mxed.END_ORDER_LINE_NUMBER, 16,mxed.END_ORDER_LINE_NUMBER, 27,mxed.END_ORDER_LINE_NUMBER, to_char(null)) SALES_ORDER_LINE ,decode(mxed.EXCEPTION_TYPE, 12, mxed.ORDER_CREATION_DATE1, 16, mxed.ORDER_CREATION_DATE1, 27, mxed.ORDER_CREATION_DATE1, to_date(null)) SO_CREATION_DATE ,decode(mxed.EXCEPTION_TYPE, 1,mxed.NUMBER1, 2,mxed.NUMBER1, 7,mxed.NUMBER1, 12,mxed.NUMBER1, 16,mxed.NUMBER1, 23,mxed.NUMBER1, 27,mxed.NUMBER1, to_number(null)) SO_QUANTITY ,decode(mxed.EXCEPTION_TYPE, 1,mxed.DATE1, 2,mxed.DATE1, 7,mxed.DATE1, 12,mxed.DATE1, 23,mxed.DATE1, 27,mxed.DATE1, to_date(null)) SO_RECEIPT_DATE ,decode(mxed.EXCEPTION_TYPE, 1,mxed.DATE3, 2,mxed.DATE3, 7,mxed.DATE3, 12,mxed.DATE1, 16,mxed.DATE1, 23,mxed.DATE3, 27,mxed.DATE3, to_date(null)) SO_SHIP_DATE ,decode(mxed.exception_type, 5, round(abs(mxed.number2-mxed.number1), 6), 6, round(abs(mxed.number2-mxed.number1), 6), 7, round(abs(mxed.number2-mxed.number1), 6), 8, round(abs(mxed.number2-mxed.number1), 6), 9, round(abs(mxed.number1+mxed.number2-mxed.item_min_qty),6), 10, round(abs(mxed.number1+mxed.number2-mxed.item_min_qty),6), to_number(null)) SHORTAGE_QUANTITY ,decode(mxed.exception_type, 5, round(abs(mxed.number2-mxed.number1)/mxed.number2*100, 6), 6, round(abs(mxed.number2-mxed.number1)/mxed.number2*100, 6), 7, round(abs(mxed.number2-mxed.number1)/mxed.number2*100, 6), 8, round(abs(mxed.number2-mxed.number1)/mxed.number1*100, 6), to_number(null)) SHORTAGE_QUANTITY_PCT ,decode(mxed.EXCEPTION_TYPE, 47, mxed.NUMBER3, 48, mxed.NUMBER3, to_number(null)) STOCK_OUTS ,mxed.SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME ,decode(mxed.EXCEPTION_TYPE, 2, mxed.END_ORDER_NUMBER, 8, mxed.END_ORDER_NUMBER, 13, mxed.END_ORDER_NUMBER, 28, mxed.END_ORDER_NUMBER, 32, mxed.END_ORDER_NUMBER, to_char(null)) SUPPLIER_SO ,decode(mxed.EXCEPTION_TYPE, 2, mxed.ORDER_CREATION_DATE1, 8, mxed.ORDER_CREATION_DATE1, 13, mxed.ORDER_CREATION_DATE1, 28, mxed.ORDER_CREATION_DATE1, to_date(null)) SUPPLIER_SO_CREATION_DATE ,decode(mxed.EXCEPTION_TYPE, 2,mxed.END_ORDER_LINE_NUMBER, 8,mxed.END_ORDER_LINE_NUMBER, 13,mxed.END_ORDER_LINE_NUMBER, 28,mxed.END_ORDER_LINE_NUMBER, 32,mxed.END_ORDER_LINE_NUMBER, to_char(null)) SUPPLIER_SO_LINE ,decode(mxed.EXCEPTION_TYPE, 2, mxed.NUMBER2, 8, mxed.NUMBER2, 13, mxed.NUMBER2, 24, mxed.NUMBER2, 28, mxed.NUMBER2, 32, mxed.NUMBER2, to_number(null)) SUPPLIER_SO_QUANTITY ,decode(mxed.EXCEPTION_TYPE, 2, mxed.DATE2, 8, mxed.DATE2, 13, mxed.DATE2, 24, mxed.DATE2, 28, mxed.DATE2, 32, mxed.ORDER_CREATION_DATE1, to_date(null)) SUPPLIER_SO_RECEIPT_DATE ,decode(mxed.EXCEPTION_TYPE, 2, mxed.DATE3, 8, mxed.DATE3, 13, mxed.DATE3, 23, mxed.DATE3, 24, mxed.DATE3, 28, mxed.DATE3, 28, mxed.DATE1, to_date(null)) SUPPLIER_SO_SHIP_DATE ,mxed.THRESHOLD ,mxed.ITEM_MIN_QTY ,mxed.ITEM_MAX_QTY ,mxed.LEAD_TIME ,floor(abs((mxed.order_creation_date1-mxed.date1)+nvl(mxed.lead_time,0))) COMPRESSION_DAYS ,round(abs(mxed.number1+mxed.number2-mxed.item_min_qty),6) VMI_SHORTAGE ,round(abs(mxed.number1+mxed.number2-mxed.item_max_qty),6) VMI_EXCESS ,mxed.COMPANY_ID ,decode(mxed.EXCEPTION_TYPE, 5, mxed.number2, 6, mxed.number2, to_number(null)) CUSTOMER_ORDER_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 5, mxed.number1, 6, mxed.number1, to_number(null)) SUPPLY_COMMIT_QTY ,decode(mxed.EXCEPTION_TYPE, 9, mxed.number2, 10, mxed.number2, 29, mxed.number2, 30, mxed.number2, to_number(null)) QTY_ON_HAND ,decode(mxed.EXCEPTION_TYPE, 9, round(abs(mxed.number1+mxed.number2-mxed.item_min_qty),6), 10, round(abs(mxed.number1+mxed.number2-mxed.item_min_qty),6), 29, mxed.number1, 30, mxed.number1, to_number(null)) QTY_ON_ORDER ,decode(mxed.EXCEPTION_TYPE, 9, mxed.exception_detail_id, 10, mxed.exception_detail_id, 29, mxed.exception_detail_id, 30, mxed.exception_detail_id, to_number(null)) INVENTORY_STATUS ,decode(mxed.EXCEPTION_TYPE, 19, mxed.number1, 21, mxed.number1, 22, mxed.number1, 25, mxed.number1, to_number(null)) SUPPLIER_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 19, mxed.number2, 20, mxed.number2, 21, mxed.number2, 22, mxed.number2, 25, mxed.number2, 35, mxed.number2, to_number(null)) CUSTOMER_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 35, mxed.number1, to_number(null)) HISTORICAL_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 20, mxed.number1, to_number(null)) YOUR_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 26,mxed.number2, 36,mxed.number2, 37,mxed.number2, 38,mxed.number2, to_number(null)) ORDER_FCST_QTY ,decode(mxed.EXCEPTION_TYPE, 36,mxed.number1, 37,mxed.number1, 38,mxed.number1, to_number(null)) ACTUAL_ORDER_QTY ,decode(mxed.EXCEPTION_TYPE, 26, mxed.number1, to_number(null)) SUPPLIER_SUPPLY_COMMIT_QTY ,decode(mxed.EXCEPTION_TYPE, 39, mxed.number3, 40, mxed.number3, to_number(null)) FCST_ERROR ,decode(mxed.EXCEPTION_TYPE, 41, mxed.number3, 42, mxed.number3, to_number(null)) FILL_RATE ,decode(mxed.EXCEPTION_TYPE, 43, mxed.number3, 44, mxed.number3, to_number(null)) DELIVERY_PERF_PCT ,msc_get_name.MSCX_UDE_PUB_ORDER_TYPE(mxed.EXCEPTION_DETAIL_ID) ,msc_get_name.MSCX_PLANNER_CODE(mxed.EXCEPTION_DETAIL_ID) ,msc_get_name.MSCX_QUANTITY(mxed.EXCEPTION_DETAIL_ID) ,msc_get_name.MSCX_COMP_RECEIPT_DATE(mxed.EXCEPTION_DETAIL_ID) ,msc_get_name.MSCX_COMP_REQUEST_DATE(mxed.EXCEPTION_DETAIL_ID) ,msc_get_name.MSCX_CUST_SHIP_DATE(mxed.EXCEPTION_DETAIL_ID) , to_char(null) DMD_SCHEDULE_ORG_CODE , to_char(null) DMD_SCHEDULE_ITEM_NAME , to_number(null) DMD_SCHEDULE_QTY , to_date(null) DMD_SCHEDULE_DUE_DATE , to_char(null) DMD_SCHEDULE_ORDER_NUMBER , to_char(null) ORIG_SOURCE_ORG_CODE , to_date(null) LATEST_ACCEPTABLE_DATE , to_char(null) ATP_OVERRIDE_FLAG , to_number(null) ORIG_LEAD_TIME , to_number(null) INTRANSIT_LEAD_TIME , to_char(null) ORIG_SHIP_METHOD , to_char(null) SHIP_METHOD , to_date(null) ORIG_SCHED_SHIP_DATE , to_date(null) SCHED_SHIP_DATE , to_date(null) ORIG_SCHED_ARRIVAL_DATE , to_date(null) SCHED_ARRIVAL_DATE , to_date(null) REQUEST_SHIP_DATE , to_date(null) REQUEST_ARRIVAL_DATE , to_date(null) PROMISE_ARRIVAL_DATE , to_date(null) PROMISE_SHIP_DATE , to_date(null) ORDER_DATE , to_number(null) EXCEPTION_BIT , to_date(null) ORDER_START_DATE , to_date(null) ORDER_DUE_DATE , to_date(null) ORDER_DOCK_DATE , to_date(null) ORDER_SHIP_DATE , to_char(null) PLANNED_BEFORE_PTF , to_number(null) OWNING_COMPANY_ID , to_char(null) DEMAND_ORGANIZATION_CODE , to_char(null) SHIP_ORGANIZATION_CODE , to_number(null) PRODUCT_FAMILY_ID , to_char(null) PRODUCT_FAMILY , to_number(null) SUBSTITUTION_PCT , to_number(null) BELOW_SS_QTY_PCT , to_char(null) CAUSE , to_date(null) BUDGET_VIOLATION_DATE , to_char(null) BUDGET_NAME , to_number(null) BUDGET_VALUE , to_number(null) INVENTORY_VALUE , to_char(null) BUDGET_VIOLATION_LEVEL , to_number(null) SPECIFIED_SERVICE_LEVEL , to_number(null) ACHIEVED_SERVICE_LEVEL , to_number(null) BUDGET_VIOLATION_LEVEL_CODE , to_char(null) RESOURCE_GROUP_NAME ,to_date(null) Required_Completion_date ,to_date(null) Scheduled_Completion_date ,to_number(null) Minimum_Transfer_Quantity ,to_number(null) Acceptable_early_delivery ,to_number(null) Setup_Hours ,to_number(null) Available_Hours ,to_number(null) Load_Ratio_from ,to_number(null) Load_Ratio_to ,to_date(null)start_date_from ,to_date(null) start_date_to ,to_date(null) End_date_from ,to_date(null) End_date_to ,to_number(null) Load_ratio_difference ,to_number(null) Load_ratio_diff_threshold ,to_char(null) ,to_char(null) ,to_char(null) ,to_date(null) requested_start_date ,to_date(null) requested_completion_date ,to_char(null) from_item ,to_char(null) to_item ,to_char(null) from_organization ,to_char(null) to_organization ,to_char(null) from_supply_order_number ,to_char(null) to_supply_order_number ,to_number(null) from_op_seq_num ,to_number(null) to_op_seq_num ,to_number(null) from_res_seq_num ,to_number(null) to_res_seq_num ,to_number(null) minimum_time_offset ,to_number(null) maximum_time_offset ,to_number(null) actual_offset ,to_number(null) shelf_life_days ,to_date(null) lot_expiration_date ,to_number(null) setup_time_ratio ,to_number(null) Exception_time_fence ,to_number(null) Exception_threshold_pct ,to_number(null) Eam_days_early ,to_number(null) Eam_days_late ,to_date(null) comp_demand_date ,to_number(null) min_remaining_shelf_life ,to_number(null) min_remaining_slf_life_planned ,to_number(null) min_remaining_slf_life_shtfall ,to_char(null) ,to_number(null) to_transaction_id ,to_number(null) charge_number ,to_number(null) planned_charge_quantity ,null from msc_x_exception_details mxed

View Text - HTML Formatted

SELECT /*+ FIRST_ROWS */ MXED.EXCEPTION_DETAIL_ID
, 2
, -1
, MXED.COMPANY_SITE_ID
, MXED.SR_INSTANCE_ID
, MXED.INVENTORY_ITEM_ID
, MXED.EXCEPTION_TYPE
, MXED.LAST_UPDATE_DATE
, MXED.LAST_UPDATED_BY
, MXED.CREATION_DATE
, MXED.CREATED_BY
, MXED.LAST_UPDATE_LOGIN
, MXED.COMPANY_SITE_NAME
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, MXED.ITEM_NAME
, TO_CHAR(NULL) ITEM_DESCRIPTION
, TO_CHAR(NULL) BUYER_NAME
, TO_CHAR(NULL) PLANNER_CODE
, EXCEPTION_TYPE_NAME
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL) PROJECT_NUMBER
, TO_CHAR(NULL) TASK_NUMBER
, TO_CHAR(NULL) PLANNING_GROUP
, TO_CHAR(NULL) TO_PROJECT_NUMBER
, TO_CHAR(NULL) TO_TASK_NUMBER
, TO_DATE(NULL) DUE_DATE
, TO_DATE(NULL) FROM_DATE
, TO_DATE(NULL) TO_DATE
, TO_NUMBER(NULL) DAYS_COMPRESSED
, TO_NUMBER(NULL) QUANTITY
, TO_CHAR(NULL) LOT_NUMBER
, TO_CHAR(NULL) ORDER_NUMBER
, TO_CHAR(NULL) SUPPLY_TYPE
, TO_CHAR(NULL) END_ITEM_SEGMENTS
, TO_CHAR(NULL) PLANNED_INVENTORY_POINT
, TO_CHAR(NULL) END_ORDER_NUMBER
, TO_NUMBER(NULL) TRANSACTION_ID
, TO_NUMBER(NULL) DEMAND_ID
, TO_NUMBER(NULL) DEPARTMENT_ID
, TO_NUMBER(NULL) RESOURCE_ID
, TO_CHAR(NULL) DEPARTMENT_LINE_CODE
, TO_CHAR(NULL) RESOURCE_CODE
, TO_NUMBER(NULL) RESOURCE_TYPE
, TO_CHAR(NULL) RESOURCE_TYPE_CODE
, TO_NUMBER(NULL) UTILIZATION_RATE
, TO_CHAR(MXED.SUPPLIER_ID)
, MXED.SUPPLIER_NAME
, TO_CHAR(MXED.SUPPLIER_SITE_ID)
, MXED.SUPPLIER_SITE_NAME
, MXED.CUSTOMER_ID
, MXED.CUSTOMER_NAME
, MXED.CUSTOMER_SITE_ID
, MXED.CUSTOMER_SITE_NAME
, TO_NUMBER(NULL) ORDER_PRIORITY
, TO_DATE(NULL) DMD_SATISFIED_DATE
, TO_CHAR(NULL) SUBSTITUTE_COMPONENT
, TO_CHAR(NULL) ALTERNATE_ROUTING_DESIGNATOR
, TO_CHAR(NULL) ALTERNATE_BOM_DESIGNATOR
, TO_NUMBER(NULL) SOURCE_ORGANIZATION_ID
, TO_NUMBER(NULL) SOURCE_ORG_INSTANCE_ID
, TO_CHAR(NULL) SOURCE_ORGANIZATION_CODE
, TO_DATE(NULL) REPLENISHMENT_DATE
, TO_NUMBER(NULL) END_PEGGING_ID
, TO_NUMBER(NULL) DEMAND_QUANTITY
, TO_DATE(NULL) OLD_DUE_DATE
, TO_CHAR(NULL) ORDER_TYPE
, TO_NUMBER(NULL) ORDER_TYPE_ID
, TO_NUMBER(NULL) BATCHABLE_FLAG
, TO_NUMBER(NULL) MIN_CAPACITY
, TO_NUMBER(NULL) MAX_CAPACITY
, TO_NUMBER(NULL) BATCH_NUMBER
, TO_NUMBER(NULL) REQUIRED_CAPACITY
, TO_NUMBER(NULL) QUANTITY_BY_DUE_DATE
, TO_NUMBER(NULL) RESOURCE_OVER_UTIL_COST
, TO_NUMBER(NULL) ALLOCATED_PERCENTAGE
, TO_NUMBER(NULL) ACTUAL_PERCENTAGE
, TO_NUMBER(NULL) PERCENT_VARIANCE
, 2 ACTION_TAKEN
, MXED.ROWID ROW_ID
, DECODE(MXED.EXCEPTION_TYPE
, 1
, ABS(MXED.DATE2-MXED.DATE1)
, 2
, ABS(MXED.DATE2-MXED.DATE1)
, 13
, NUMBER3
, 50
, NUMBER3
, 51
, NUMBER3
, TO_NUMBER(NULL)) DAYS_LATE
, TO_NUMBER(NULL) SUBSTITUTE_ITEM_ID
, TO_CHAR(NULL) SUBSTITUTE_ITEM_NAME
, TO_NUMBER(NULL) SUBSTITUTE_ORG_ID
, TO_CHAR(NULL) SUBSTITUTE_ORG_CODE
, TO_NUMBER(NULL) SUBSTITUTE_QTY
, TO_NUMBER(NULL) PREFERENCE
, TO_NUMBER(NULL) ORIGINATION_TYPE_ID
, TO_CHAR(NULL) ORIGINATION_TYPE
, TO_NUMBER(NULL) DEMAND_DATE_QUANTITY
, TO_CHAR(NULL) DEMAND_CLASS
, TO_NUMBER(NULL) OPERATION_SEQ_NUM
, TO_NUMBER(NULL) RESOURCE_SEQ_NUM
, TO_CHAR(NULL) FIRM_TYPE
, TO_NUMBER(NULL) FIRM_PLANNED_TYPE
, TO_DATE(NULL) MIN_START_TIME
, TO_NUMBER(NULL) MIN_LEAD_TIME
, TO_DATE(NULL) NEW_DOCK_DATE
, TO_NUMBER(NULL) AVAILABLE_CAPACITY
, TO_NUMBER(NULL) QTY_MISMATCH
, TO_NUMBER(NULL) ACTUAL_DURATION
, TO_CHAR(NULL) SUPPLY_ORGANIZATION_CODE
, TO_NUMBER(NULL) SUPPLY_ORGANIZATION_ID
, TO_NUMBER(NULL) SUPPLY_SR_INSTANCE_ID
, TO_CHAR(NULL) SUPPLY_ITEM_SEGMENTS
, TO_NUMBER(NULL) SUPPLY_INVENTORY_ITEM_ID
, TO_CHAR(NULL) SUPPLY_PLANNER_CODE
, TO_CHAR(NULL) SUPPLY_ORDER_TYPE
, TO_NUMBER(NULL) SUPPLY_ORDER_TYPE_ID
, TO_NUMBER(NULL) SUPPLY_SUPPLIER_ID
, TO_CHAR(NULL) SUPPLY_SUPPLIER_NAME
, TO_NUMBER(NULL) SUPPLY_SUPPLIER_SITE_ID
, TO_CHAR(NULL) SUPPLY_SUPPLIER_SITE
, TO_CHAR(NULL) SUPPLY_SOURCE_ORGA_CODE
, TO_NUMBER(NULL) SUPPLY_SOURCE_ORG_ID
, TO_NUMBER(NULL) SUPPLY_SOURCE_SR_INSTANCE_ID
, TO_CHAR(NULL) SUPPLY_PLANNING_GROUP
, TO_NUMBER(NULL) SUPPLY_PROJECT_ID
, TO_CHAR(NULL) SUPPLY_PROJECT_NUMBER
, TO_NUMBER(NULL) SUPPLY_TASK_ID
, TO_CHAR(NULL) SUPPLY_TASK_NUMBER
, TO_NUMBER(NULL) SALES_ORDER_LINE_PRICE
, TO_NUMBER(NULL) DUE_DATE_QTY_PCT
, TO_NUMBER(NULL) COMPRESSION_PCT
, TO_NUMBER(NULL) CONSTRAINT_PCT
, TO_NUMBER(NULL) DAYS_EARLY_BEFORE_LADATE
, TO_NUMBER(NULL) DAYS_EARLY_ARRIVAL
, TO_NUMBER(NULL) DAYS_PAST
, TO_NUMBER(NULL) DAYS_LATE_BEYOND_LADATE
, TO_NUMBER(NULL) DAYS_LATE_ARRIVAL
, TO_NUMBER(NULL) EXCESS_DURATION
, TO_NUMBER(NULL) RESCHEDULE_IN_DAYS
, TO_NUMBER(NULL) RESCHEDULE_OUT_DAYS
, TO_NUMBER(NULL) QTY_MISMATCH_PCT
, TO_NUMBER(NULL) SS_QUANTITY
, TO_NUMBER(NULL) SHORTAGE_DURATION
, TO_DATE(NULL) JUST_DATE
, TO_CHAR(NULL) TO_PLANNING_GROUP
, TO_NUMBER(NULL) DEST_ORGANIZATION_ID
, TO_NUMBER(NULL) DEST_SR_INSTANCE_ID
, TO_CHAR(NULL) DEST_ORGANIZATION_CODE
, MXED.CUSTOMER_ITEM_NAME
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.ORDER_NUMBER
, 3
, MXED.ORDER_NUMBER
, 7
, MXED.ORDER_NUMBER
, 11
, MXED.ORDER_NUMBER
, 23
, MXED.ORDER_NUMBER
, 27
, MXED.ORDER_NUMBER
, 33
, MXED.ORDER_NUMBER
, 34
, MXED.ORDER_NUMBER
, TO_CHAR(NULL)) CUSTOMER_PO
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.ORDER_CREATION_DATE1
, 3
, MXED.ORDER_CREATION_DATE1
, 7
, MXED.ORDER_CREATION_DATE1
, 11
, MXED.ORDER_CREATION_DATE1
, 23
, MXED.ORDER_CREATION_DATE1
, 27
, MXED.ORDER_CREATION_DATE1
, 33
, MXED.ORDER_CREATION_DATE1
, 34
, MXED.ORDER_CREATION_DATE1
, TO_DATE(NULL)) CUSTOMER_PO_CREATION_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.LINE_NUMBER
, 3
, MXED.LINE_NUMBER
, 7
, MXED.LINE_NUMBER
, 11
, MXED.LINE_NUMBER
, 23
, MXED.LINE_NUMBER
, 27
, MXED.LINE_NUMBER
, 33
, MXED.LINE_NUMBER
, 34
, MXED.LINE_NUMBER
, TO_CHAR(NULL)) CUSTOMER_PO_LINE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.DATE2
, 3
, MXED.DATE1
, 7
, MXED.DATE2
, 11
, MXED.DATE1
, 23
, MXED.DATE2
, 27
, MXED.DATE2
, TO_DATE(NULL)) CUSTOMER_PO_NEED_BY_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.NUMBER2
, 3
, MXED.NUMBER1
, 7
, MXED.NUMBER2
, 11
, MXED.NUMBER1
, 23
, MXED.NUMBER2
, 27
, MXED.NUMBER2
, 33
, MXED.NUMBER1
, 34
, MXED.NUMBER1
, TO_NUMBER(NULL)) CUSTOMER_PO_QUANTITY
, TO_DATE(NULL) CUSTOMER_PO_RECEIPT_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 33
, MXED.DATE1
, TO_DATE(NULL)) CUSTOMER_PO_CANCEL_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 34
, MXED.DATE1
, TO_DATE(NULL)) CUSTOMER_PO_UPDATED_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.RELEASE_NUMBER
, 3
, MXED.RELEASE_NUMBER
, 7
, MXED.RELEASE_NUMBER
, 11
, MXED.RELEASE_NUMBER
, 23
, MXED.RELEASE_NUMBER
, 27
, MXED.RELEASE_NUMBER
, TO_CHAR(NULL)) CUSTOMER_PO_RELEASE
, DECODE(MXED.EXCEPTION_TYPE
, 23
, ABS(MXED.DATE2-MXED.DATE1)
, 24
, ABS(MXED.DATE2-MXED.DATE1)
, TO_NUMBER(NULL)) DAYS_EARLY
, DECODE(MXED.EXCEPTION_TYPE
, 3
, SYSDATE-MXED.DATE1
, 4
, SYSDATE-MXED.DATE1
, TO_DATE(NULL)) DAYS_PAST_DUE
, DECODE(MXED.EXCEPTION_TYPE
, 25
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 26
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 27
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 28
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 29
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MAX_QTY)
, 6)
, 30
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MAX_QTY)
, 6)
, TO_NUMBER(NULL)) EXCESS_QUANTITY
, DECODE(MXED.EXCEPTION_TYPE
, 25
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER1 * 100
, 6)
, 26
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER1 * 100
, 6)
, 27
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER1 * 100
, 6)
, 28
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER1 * 100
, 6)
, TO_NUMBER(NULL)) EXCESS_QUANTITY_PCT
, DECODE(MXED.EXCEPTION_TYPE
, 45
, MXED.NUMBER3
, 46
, MXED.NUMBER3
, TO_NUMBER(NULL)) INVENTORY_TURNS
, MXED.DATE2 PERIOD_END_DATE
, MXED.DATE1 PERIOD_START_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.ORDER_NUMBER
, 4
, MXED.ORDER_NUMBER
, 8
, MXED.ORDER_NUMBER
, 13
, MXED.ORDER_NUMBER
, 14
, MXED.ORDER_NUMBER
, 24
, MXED.ORDER_NUMBER
, 28
, MXED.ORDER_NUMBER
, 31
, MXED.ORDER_NUMBER
, 49
, MXED.ORDER_NUMBER
, TO_CHAR(NULL)) PURCHASE_ORDER
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.ORDER_CREATION_DATE1
, 4
, MXED.ORDER_CREATION_DATE1
, 8
, MXED.ORDER_CREATION_DATE1
, 13
, MXED.ORDER_CREATION_DATE1
, 14
, MXED.ORDER_CREATION_DATE1
, 24
, MXED.ORDER_CREATION_DATE1
, 28
, MXED.ORDER_CREATION_DATE1
, 31
, MXED.ORDER_CREATION_DATE1
, 49
, MXED.ORDER_CREATION_DATE1
, TO_DATE(NULL)) PO_CREATION_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.DATE1
, 4
, MXED.DATE1
, 8
, MXED.DATE1
, 13
, MXED.DATE1
, 14
, MXED.DATE1
, 24
, MXED.DATE1
, 28
, MXED.DATE1
, 31
, MXED.DATE1
, 49
, MXED.DATE1
, TO_DATE(NULL)) PO_NEED_BY_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 49
, MXED.DATE2
, TO_DATE(NULL)) PO_UPDATE_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.NUMBER1
, 4
, MXED.NUMBER2
, 8
, MXED.NUMBER1
, 13
, MXED.NUMBER1
, 14
, MXED.NUMBER1
, 24
, MXED.NUMBER1
, 28
, MXED.NUMBER1
, 31
, MXED.NUMBER1
, 49
, MXED.NUMBER1
, TO_NUMBER(NULL)) PO_QUANTITY
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.END_ORDER_NUMBER
, 2
, MXED.END_ORDER_NUMBER
, 7
, MXED.END_ORDER_NUMBER
, 12
, MXED.END_ORDER_NUMBER
, 16
, MXED.END_ORDER_NUMBER
, 27
, MXED.END_ORDER_NUMBER
, TO_CHAR(NULL)) SALES_ORDER
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.END_ORDER_LINE_NUMBER
, 2
, MXED.END_ORDER_LINE_NUMBER
, 7
, MXED.END_ORDER_LINE_NUMBER
, 12
, MXED.END_ORDER_LINE_NUMBER
, 16
, MXED.END_ORDER_LINE_NUMBER
, 27
, MXED.END_ORDER_LINE_NUMBER
, TO_CHAR(NULL)) SALES_ORDER_LINE
, DECODE(MXED.EXCEPTION_TYPE
, 12
, MXED.ORDER_CREATION_DATE1
, 16
, MXED.ORDER_CREATION_DATE1
, 27
, MXED.ORDER_CREATION_DATE1
, TO_DATE(NULL)) SO_CREATION_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.NUMBER1
, 2
, MXED.NUMBER1
, 7
, MXED.NUMBER1
, 12
, MXED.NUMBER1
, 16
, MXED.NUMBER1
, 23
, MXED.NUMBER1
, 27
, MXED.NUMBER1
, TO_NUMBER(NULL)) SO_QUANTITY
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.DATE1
, 2
, MXED.DATE1
, 7
, MXED.DATE1
, 12
, MXED.DATE1
, 23
, MXED.DATE1
, 27
, MXED.DATE1
, TO_DATE(NULL)) SO_RECEIPT_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 1
, MXED.DATE3
, 2
, MXED.DATE3
, 7
, MXED.DATE3
, 12
, MXED.DATE1
, 16
, MXED.DATE1
, 23
, MXED.DATE3
, 27
, MXED.DATE3
, TO_DATE(NULL)) SO_SHIP_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 5
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 6
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 7
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 8
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)
, 6)
, 9
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MIN_QTY)
, 6)
, 10
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MIN_QTY)
, 6)
, TO_NUMBER(NULL)) SHORTAGE_QUANTITY
, DECODE(MXED.EXCEPTION_TYPE
, 5
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER2*100
, 6)
, 6
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER2*100
, 6)
, 7
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER2*100
, 6)
, 8
, ROUND(ABS(MXED.NUMBER2-MXED.NUMBER1)/MXED.NUMBER1*100
, 6)
, TO_NUMBER(NULL)) SHORTAGE_QUANTITY_PCT
, DECODE(MXED.EXCEPTION_TYPE
, 47
, MXED.NUMBER3
, 48
, MXED.NUMBER3
, TO_NUMBER(NULL)) STOCK_OUTS
, MXED.SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.END_ORDER_NUMBER
, 8
, MXED.END_ORDER_NUMBER
, 13
, MXED.END_ORDER_NUMBER
, 28
, MXED.END_ORDER_NUMBER
, 32
, MXED.END_ORDER_NUMBER
, TO_CHAR(NULL)) SUPPLIER_SO
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.ORDER_CREATION_DATE1
, 8
, MXED.ORDER_CREATION_DATE1
, 13
, MXED.ORDER_CREATION_DATE1
, 28
, MXED.ORDER_CREATION_DATE1
, TO_DATE(NULL)) SUPPLIER_SO_CREATION_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.END_ORDER_LINE_NUMBER
, 8
, MXED.END_ORDER_LINE_NUMBER
, 13
, MXED.END_ORDER_LINE_NUMBER
, 28
, MXED.END_ORDER_LINE_NUMBER
, 32
, MXED.END_ORDER_LINE_NUMBER
, TO_CHAR(NULL)) SUPPLIER_SO_LINE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.NUMBER2
, 8
, MXED.NUMBER2
, 13
, MXED.NUMBER2
, 24
, MXED.NUMBER2
, 28
, MXED.NUMBER2
, 32
, MXED.NUMBER2
, TO_NUMBER(NULL)) SUPPLIER_SO_QUANTITY
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.DATE2
, 8
, MXED.DATE2
, 13
, MXED.DATE2
, 24
, MXED.DATE2
, 28
, MXED.DATE2
, 32
, MXED.ORDER_CREATION_DATE1
, TO_DATE(NULL)) SUPPLIER_SO_RECEIPT_DATE
, DECODE(MXED.EXCEPTION_TYPE
, 2
, MXED.DATE3
, 8
, MXED.DATE3
, 13
, MXED.DATE3
, 23
, MXED.DATE3
, 24
, MXED.DATE3
, 28
, MXED.DATE3
, 28
, MXED.DATE1
, TO_DATE(NULL)) SUPPLIER_SO_SHIP_DATE
, MXED.THRESHOLD
, MXED.ITEM_MIN_QTY
, MXED.ITEM_MAX_QTY
, MXED.LEAD_TIME
, FLOOR(ABS((MXED.ORDER_CREATION_DATE1-MXED.DATE1)+NVL(MXED.LEAD_TIME
, 0))) COMPRESSION_DAYS
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MIN_QTY)
, 6) VMI_SHORTAGE
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MAX_QTY)
, 6) VMI_EXCESS
, MXED.COMPANY_ID
, DECODE(MXED.EXCEPTION_TYPE
, 5
, MXED.NUMBER2
, 6
, MXED.NUMBER2
, TO_NUMBER(NULL)) CUSTOMER_ORDER_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 5
, MXED.NUMBER1
, 6
, MXED.NUMBER1
, TO_NUMBER(NULL)) SUPPLY_COMMIT_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 9
, MXED.NUMBER2
, 10
, MXED.NUMBER2
, 29
, MXED.NUMBER2
, 30
, MXED.NUMBER2
, TO_NUMBER(NULL)) QTY_ON_HAND
, DECODE(MXED.EXCEPTION_TYPE
, 9
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MIN_QTY)
, 6)
, 10
, ROUND(ABS(MXED.NUMBER1+MXED.NUMBER2-MXED.ITEM_MIN_QTY)
, 6)
, 29
, MXED.NUMBER1
, 30
, MXED.NUMBER1
, TO_NUMBER(NULL)) QTY_ON_ORDER
, DECODE(MXED.EXCEPTION_TYPE
, 9
, MXED.EXCEPTION_DETAIL_ID
, 10
, MXED.EXCEPTION_DETAIL_ID
, 29
, MXED.EXCEPTION_DETAIL_ID
, 30
, MXED.EXCEPTION_DETAIL_ID
, TO_NUMBER(NULL)) INVENTORY_STATUS
, DECODE(MXED.EXCEPTION_TYPE
, 19
, MXED.NUMBER1
, 21
, MXED.NUMBER1
, 22
, MXED.NUMBER1
, 25
, MXED.NUMBER1
, TO_NUMBER(NULL)) SUPPLIER_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 19
, MXED.NUMBER2
, 20
, MXED.NUMBER2
, 21
, MXED.NUMBER2
, 22
, MXED.NUMBER2
, 25
, MXED.NUMBER2
, 35
, MXED.NUMBER2
, TO_NUMBER(NULL)) CUSTOMER_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 35
, MXED.NUMBER1
, TO_NUMBER(NULL)) HISTORICAL_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 20
, MXED.NUMBER1
, TO_NUMBER(NULL)) YOUR_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 26
, MXED.NUMBER2
, 36
, MXED.NUMBER2
, 37
, MXED.NUMBER2
, 38
, MXED.NUMBER2
, TO_NUMBER(NULL)) ORDER_FCST_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 36
, MXED.NUMBER1
, 37
, MXED.NUMBER1
, 38
, MXED.NUMBER1
, TO_NUMBER(NULL)) ACTUAL_ORDER_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 26
, MXED.NUMBER1
, TO_NUMBER(NULL)) SUPPLIER_SUPPLY_COMMIT_QTY
, DECODE(MXED.EXCEPTION_TYPE
, 39
, MXED.NUMBER3
, 40
, MXED.NUMBER3
, TO_NUMBER(NULL)) FCST_ERROR
, DECODE(MXED.EXCEPTION_TYPE
, 41
, MXED.NUMBER3
, 42
, MXED.NUMBER3
, TO_NUMBER(NULL)) FILL_RATE
, DECODE(MXED.EXCEPTION_TYPE
, 43
, MXED.NUMBER3
, 44
, MXED.NUMBER3
, TO_NUMBER(NULL)) DELIVERY_PERF_PCT
, MSC_GET_NAME.MSCX_UDE_PUB_ORDER_TYPE(MXED.EXCEPTION_DETAIL_ID)
, MSC_GET_NAME.MSCX_PLANNER_CODE(MXED.EXCEPTION_DETAIL_ID)
, MSC_GET_NAME.MSCX_QUANTITY(MXED.EXCEPTION_DETAIL_ID)
, MSC_GET_NAME.MSCX_COMP_RECEIPT_DATE(MXED.EXCEPTION_DETAIL_ID)
, MSC_GET_NAME.MSCX_COMP_REQUEST_DATE(MXED.EXCEPTION_DETAIL_ID)
, MSC_GET_NAME.MSCX_CUST_SHIP_DATE(MXED.EXCEPTION_DETAIL_ID)
, TO_CHAR(NULL) DMD_SCHEDULE_ORG_CODE
, TO_CHAR(NULL) DMD_SCHEDULE_ITEM_NAME
, TO_NUMBER(NULL) DMD_SCHEDULE_QTY
, TO_DATE(NULL) DMD_SCHEDULE_DUE_DATE
, TO_CHAR(NULL) DMD_SCHEDULE_ORDER_NUMBER
, TO_CHAR(NULL) ORIG_SOURCE_ORG_CODE
, TO_DATE(NULL) LATEST_ACCEPTABLE_DATE
, TO_CHAR(NULL) ATP_OVERRIDE_FLAG
, TO_NUMBER(NULL) ORIG_LEAD_TIME
, TO_NUMBER(NULL) INTRANSIT_LEAD_TIME
, TO_CHAR(NULL) ORIG_SHIP_METHOD
, TO_CHAR(NULL) SHIP_METHOD
, TO_DATE(NULL) ORIG_SCHED_SHIP_DATE
, TO_DATE(NULL) SCHED_SHIP_DATE
, TO_DATE(NULL) ORIG_SCHED_ARRIVAL_DATE
, TO_DATE(NULL) SCHED_ARRIVAL_DATE
, TO_DATE(NULL) REQUEST_SHIP_DATE
, TO_DATE(NULL) REQUEST_ARRIVAL_DATE
, TO_DATE(NULL) PROMISE_ARRIVAL_DATE
, TO_DATE(NULL) PROMISE_SHIP_DATE
, TO_DATE(NULL) ORDER_DATE
, TO_NUMBER(NULL) EXCEPTION_BIT
, TO_DATE(NULL) ORDER_START_DATE
, TO_DATE(NULL) ORDER_DUE_DATE
, TO_DATE(NULL) ORDER_DOCK_DATE
, TO_DATE(NULL) ORDER_SHIP_DATE
, TO_CHAR(NULL) PLANNED_BEFORE_PTF
, TO_NUMBER(NULL) OWNING_COMPANY_ID
, TO_CHAR(NULL) DEMAND_ORGANIZATION_CODE
, TO_CHAR(NULL) SHIP_ORGANIZATION_CODE
, TO_NUMBER(NULL) PRODUCT_FAMILY_ID
, TO_CHAR(NULL) PRODUCT_FAMILY
, TO_NUMBER(NULL) SUBSTITUTION_PCT
, TO_NUMBER(NULL) BELOW_SS_QTY_PCT
, TO_CHAR(NULL) CAUSE
, TO_DATE(NULL) BUDGET_VIOLATION_DATE
, TO_CHAR(NULL) BUDGET_NAME
, TO_NUMBER(NULL) BUDGET_VALUE
, TO_NUMBER(NULL) INVENTORY_VALUE
, TO_CHAR(NULL) BUDGET_VIOLATION_LEVEL
, TO_NUMBER(NULL) SPECIFIED_SERVICE_LEVEL
, TO_NUMBER(NULL) ACHIEVED_SERVICE_LEVEL
, TO_NUMBER(NULL) BUDGET_VIOLATION_LEVEL_CODE
, TO_CHAR(NULL) RESOURCE_GROUP_NAME
, TO_DATE(NULL) REQUIRED_COMPLETION_DATE
, TO_DATE(NULL) SCHEDULED_COMPLETION_DATE
, TO_NUMBER(NULL) MINIMUM_TRANSFER_QUANTITY
, TO_NUMBER(NULL) ACCEPTABLE_EARLY_DELIVERY
, TO_NUMBER(NULL) SETUP_HOURS
, TO_NUMBER(NULL) AVAILABLE_HOURS
, TO_NUMBER(NULL) LOAD_RATIO_FROM
, TO_NUMBER(NULL) LOAD_RATIO_TO
, TO_DATE(NULL)START_DATE_FROM
, TO_DATE(NULL) START_DATE_TO
, TO_DATE(NULL) END_DATE_FROM
, TO_DATE(NULL) END_DATE_TO
, TO_NUMBER(NULL) LOAD_RATIO_DIFFERENCE
, TO_NUMBER(NULL) LOAD_RATIO_DIFF_THRESHOLD
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL) REQUESTED_START_DATE
, TO_DATE(NULL) REQUESTED_COMPLETION_DATE
, TO_CHAR(NULL) FROM_ITEM
, TO_CHAR(NULL) TO_ITEM
, TO_CHAR(NULL) FROM_ORGANIZATION
, TO_CHAR(NULL) TO_ORGANIZATION
, TO_CHAR(NULL) FROM_SUPPLY_ORDER_NUMBER
, TO_CHAR(NULL) TO_SUPPLY_ORDER_NUMBER
, TO_NUMBER(NULL) FROM_OP_SEQ_NUM
, TO_NUMBER(NULL) TO_OP_SEQ_NUM
, TO_NUMBER(NULL) FROM_RES_SEQ_NUM
, TO_NUMBER(NULL) TO_RES_SEQ_NUM
, TO_NUMBER(NULL) MINIMUM_TIME_OFFSET
, TO_NUMBER(NULL) MAXIMUM_TIME_OFFSET
, TO_NUMBER(NULL) ACTUAL_OFFSET
, TO_NUMBER(NULL) SHELF_LIFE_DAYS
, TO_DATE(NULL) LOT_EXPIRATION_DATE
, TO_NUMBER(NULL) SETUP_TIME_RATIO
, TO_NUMBER(NULL) EXCEPTION_TIME_FENCE
, TO_NUMBER(NULL) EXCEPTION_THRESHOLD_PCT
, TO_NUMBER(NULL) EAM_DAYS_EARLY
, TO_NUMBER(NULL) EAM_DAYS_LATE
, TO_DATE(NULL) COMP_DEMAND_DATE
, TO_NUMBER(NULL) MIN_REMAINING_SHELF_LIFE
, TO_NUMBER(NULL) MIN_REMAINING_SLF_LIFE_PLANNED
, TO_NUMBER(NULL) MIN_REMAINING_SLF_LIFE_SHTFALL
, TO_CHAR(NULL)
, TO_NUMBER(NULL) TO_TRANSACTION_ID
, TO_NUMBER(NULL) CHARGE_NUMBER
, TO_NUMBER(NULL) PLANNED_CHARGE_QUANTITY
, NULL
FROM MSC_X_EXCEPTION_DETAILS MXED