機械翻訳について

MSC_ORDERS_BM_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前

BM_RUN_ID DEMAND_LEAD_TIME_DATE USR_DEF_DMD_LEAD_TIME_DATE DEMAND_FULFILLMENT_LEAD_TIME REASON_CODE DEMAND_PRIORITY NEW_PROMISED_DATE OLD_PROMISED_DATE SOURCE_ORGANIZATION_ID FIRM_SALES_ORDER FIRM_SHIP_FROM_ORG FIRM_SHIP_SET_NAME FIRM_ARRIVAL_SET_NAME EARLIEST_PROMISED_DATE EXPECTED_SHIP_DATE EXPECTED_ARRIVAL_DATE SCHEDULING_STATUS_CODE ECC_FLAG PULL_IN_FLAG MANUAL_OVERRIDE_FLAG EXPECTED_SHIP_METHOD_ID EXPECTED_CARRIER_ID EXPECTED_SERVICE_LEVEL_ID EXPECTED_SUPPLIER_ID EXPECTED_MODE_OF_TRANSPORT_ID EXPECTED_SUPPLIER_SITE_ID EXPECTED_ORGANIZATION_ID EXPECTED_SHIP_FROM_WAREHOUSE EXPECTED_SHIP_FROM_WARE_NAME EXPECTED_DSHIP_SUPPLIER EXPECTED_DSHIP_SUPP_SITE EXPECTED_CARRIER DEMAND_ID BASE_DEMAND_ID CUSTOMER_ID CUSTOMER_SITE_ID DEMAND_CLASS DEMAND_CLASS_CODE SELLING_PRICE ORCH_ORDER_HEADER_ID ORCH_ORDER_LINE_ID CARRIER_ID MODE_OF_TRANSPORT RESERVATION_ID RESERVED_QUANTITY PLANNED_SHIP_DATE ITEM ITEM_DESCRIPTION ORGANIZATION_ID SCHEDULED_SHIP_FROM_ORG_ID SHIP_MODEL_COMPLETE_FLAG ORIGINAL_ITEM_ID RECEIVING_ORG_ID CONFIGURATION_ITEM SUPPLIER_ID SCHEDULED_SUPPLIER_ID SUPPLIER_SITE_ID SCHEDULED_SUPPLIER_SITE_ID USING_REQUIREMENT_QUANTITY SERVICE_LEVEL LATEST_ACCEPTABLE_SHIP_DATE LATEST_ACCEPTABLE_ARRIVAL_DATE EARLIEST_ACCEPT_SHIP_DATE EARLIEST_ACCEPT_ARRIVAL_DATE ORDER_DATE_TYPE_CODE SHIP_METHOD REQUESTED_SHIP_METHOD SCHEDULE_ARRIVAL_DATE USING_ASSEMBLY_DEMAND_DATE ZONE_ID ROOT_FULFILLMENT_LINE SHIP_SET_ID SHIP_SET_NAME ORIGINAL_SHIP_SET_ID ORIGINAL_SHIP_SET_NAME SET_TYPE ORIGINAL_PRIORITY SALES_ORDER_LINE_SPLIT ISSUED_QUANTITY FULFILLMENT_COST SHIPPING_PREFERENCE UOM_CODE ORDERED_UOM UOM_RATE SALES_ORDER_NUMBER SO_LINE_NUM ORDER_NUMBER LATEST_ACCEPTABLE_DATE BOM_ITEM_TYPE BOM_ITEM_TYPE_CODE ITEM_SUB_TYPE_CODE ORDER_TYPE_CODE REQUEST_SHIP_DATE SCHEDULE_SHIP_DATE SALES_ORDER_LINE_ID RESERVATION_STATUS_VALUE ORDER_MARGIN EARLIEST_ACCEPTABLE_DATE PROMISED_ARRIVAL_DATE PROMISED_SHIP_DATE REQUESTED_ARRIVAL_DATE SCHEDULED_ITEM SCHEDULED_ITEM_DESCRIPTION ORDER_LINE_NUMBER CATEGORY_NAME NAME_OF_CATEGORY CATALOG_NAME ORGANIZATION_NAME ORGANIZATION SCHEDULED_SHIP_FROM_WAREHOUSE SCHEDULED_SHIP_FROM_WARE_NAME ORDER_TYPE REQUEST_DATE SCHEDULE_DATE DAYS_LATE ORDER_REVENUE ORIGINAL_ORG_ID DEMAND_TYPE USING_ASSEMBLY_ITEM_ID ORIGINAL_QUANTITY SOURCE_ORG_INSTANCE_ID DEMAND_SOURCE_INSTANCE ALLOW_SPLITS ALLOW_SUBSTITUTION FULFILLMENT_LINE_NUM MIN_PERCENTAGE_FOR_SPLIT MIN_QUANTITY_FOR_SPLIT ORCH_ORDER_LINE_NUMBER ORCH_ORDER_NUMBER PROMISE_DATE PROMISING_SYSTEM COMPLETED_QUANTITY DEMAND_SOURCE_TYPE SOURCE_DOCUMENT_LINE_NUMBER SOURCE_DOCUMENT_NUMBER DEMAND_SOURCE_SYSTEM_ID INVENTORY_ITEM_ID CATEGORY_ID CATEGORY_SET_ID PARENT_FULFILLMENT_LINE SET_PARENT_FULFILLMENT_LINE FULFILLMENT_LINE CUSTOMER_NAME CUSTOMER_NUMBER CUSTOMER_SHIP_SITE REQUESTED_QUANTITY SCHEDULED_QUANTITY SCHEDULED_DROPSHIP_SUPPLIER SCHEDULED_DROPSHIP_SUP_SITE FULFILLMENT_MODE SCHEDULED_CARRIER SCHEDULED_DAYS_OF_DELAYS SCHEDULED_MODE_OF_TRANSPORT EXPECTED_MODE_OF_TRANSPORT SCHEDULED_SERVICE_LEVEL EXPECTED_SERVICE_LEVEL RELEASE_STATUS RELEASE_STATUS_ORIG PLANNER_CODE OBJECT_VERSION_NUMBER SUPPLIER_SITE_SOURCE_SYSTEM_ID SCHED_SUP_SITE_SYSTEM_ID SCHED_SUP_SITE_SYSTEM INTERNAL_ORDER_TYPE LAST_UPDATED_BY LAST_UPDATE_DATE SET_HEADER_NAME ROW_TYPE OVERRIDE_PRIORITY EXPECTED_DATE REQUESTED_DATE MODIFIED CREATION_DATE INQUIRY_DEMAND EXPENSE_TRANSFER SOURCE_DOC_ORDER_TYPE_STR REMOVED_FROM_SET ORDER_LINE_STATUS CONSTRAINT_RANK DAYS_POTENTIALLY_IMPROVE PLANNED_DATE_WITHOUT_ITEM SPLIT_INDICATOR ORIG_PARENT_FUL_LINE ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ATTRIBUTE_DATE16 ATTRIBUTE_DATE17 ATTRIBUTE_DATE18 ATTRIBUTE_DATE19 ATTRIBUTE_DATE20 GLOBAL_ATTRIBUTE_CHAR1 GLOBAL_ATTRIBUTE_CHAR2 GLOBAL_ATTRIBUTE_CHAR3 GLOBAL_ATTRIBUTE_CHAR4 GLOBAL_ATTRIBUTE_CHAR5 GLOBAL_ATTRIBUTE_CHAR6 GLOBAL_ATTRIBUTE_CHAR7 GLOBAL_ATTRIBUTE_CHAR8 GLOBAL_ATTRIBUTE_CHAR9 GLOBAL_ATTRIBUTE_CHAR10 GLOBAL_ATTRIBUTE_CHAR11 GLOBAL_ATTRIBUTE_CHAR12 GLOBAL_ATTRIBUTE_CHAR13 GLOBAL_ATTRIBUTE_CHAR14 GLOBAL_ATTRIBUTE_CHAR15 GLOBAL_ATTRIBUTE_CHAR16 GLOBAL_ATTRIBUTE_CHAR17 GLOBAL_ATTRIBUTE_CHAR18 GLOBAL_ATTRIBUTE_CHAR19 GLOBAL_ATTRIBUTE_CHAR20 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER6 GLOBAL_ATTRIBUTE_NUMBER7 GLOBAL_ATTRIBUTE_NUMBER8 GLOBAL_ATTRIBUTE_NUMBER9 GLOBAL_ATTRIBUTE_NUMBER10 GLOBAL_ATTRIBUTE_NUMBER11 GLOBAL_ATTRIBUTE_NUMBER12 GLOBAL_ATTRIBUTE_NUMBER13 GLOBAL_ATTRIBUTE_NUMBER14 GLOBAL_ATTRIBUTE_NUMBER15 GLOBAL_ATTRIBUTE_NUMBER16 GLOBAL_ATTRIBUTE_NUMBER17 GLOBAL_ATTRIBUTE_NUMBER18 GLOBAL_ATTRIBUTE_NUMBER19 GLOBAL_ATTRIBUTE_NUMBER20 GLOBAL_ATTRIBUTE_NUMBER21 GLOBAL_ATTRIBUTE_NUMBER22 GLOBAL_ATTRIBUTE_NUMBER23 GLOBAL_ATTRIBUTE_NUMBER24 GLOBAL_ATTRIBUTE_NUMBER25 GLOBAL_ATTRIBUTE_NUMBER26 GLOBAL_ATTRIBUTE_NUMBER27 GLOBAL_ATTRIBUTE_NUMBER28 GLOBAL_ATTRIBUTE_NUMBER29 GLOBAL_ATTRIBUTE_NUMBER30 GLOBAL_ATTRIBUTE_NUMBER31 GLOBAL_ATTRIBUTE_NUMBER32 GLOBAL_ATTRIBUTE_NUMBER33 GLOBAL_ATTRIBUTE_NUMBER34 GLOBAL_ATTRIBUTE_NUMBER35 GLOBAL_ATTRIBUTE_NUMBER36 GLOBAL_ATTRIBUTE_NUMBER37 GLOBAL_ATTRIBUTE_NUMBER38 GLOBAL_ATTRIBUTE_NUMBER39 GLOBAL_ATTRIBUTE_NUMBER40 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE6 GLOBAL_ATTRIBUTE_DATE7 GLOBAL_ATTRIBUTE_DATE8 GLOBAL_ATTRIBUTE_DATE9 GLOBAL_ATTRIBUTE_DATE10 GLOBAL_ATTRIBUTE_DATE11 GLOBAL_ATTRIBUTE_DATE12 GLOBAL_ATTRIBUTE_DATE13 GLOBAL_ATTRIBUTE_DATE14 GLOBAL_ATTRIBUTE_DATE15 GLOBAL_ATTRIBUTE_DATE16 GLOBAL_ATTRIBUTE_DATE17 GLOBAL_ATTRIBUTE_DATE18 GLOBAL_ATTRIBUTE_DATE19 GLOBAL_ATTRIBUTE_DATE20

問合せ

SQL_Statement

SELECT BMRUNEO.BM_RUN_ID, nvl(BMRUNEO.USR_DEF_DMD_LEAD_TIME_DATE,BMRUNEO.DEMAND_LEAD_TIME_DATE) AS DEMAND_LEAD_TIME_DATE, BMRUNEO.USR_DEF_DMD_LEAD_TIME_DATE, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.DEMAND_FULFILLMENT_LEAD_TIME,null) AS DEMAND_FULFILLMENT_LEAD_TIME, BMRUNEO.REASON_CODE, BMRUNEO.DEMAND_PRIORITY, BMRUNEO.NEW_PROMISED_DATE, BMRUNEO.OLD_PROMISED_DATE, BMRUNEO.SOURCE_ORGANIZATION_ID, BMRUNEO.FIRM_SALES_ORDER, BMRUNEO.FIRM_SHIP_FROM_ORG, BMRUNEO.FIRM_SHIP_SET_NAME, BMRUNEO.FIRM_ARRIVAL_SET_NAME, BMRUNEO.EARLIEST_PROMISED_DATE, BMRUNEO.EXPECTED_SHIP_DATE, BMRUNEO.EXPECTED_ARRIVAL_DATE, ( case when decode(DemandsEO.supplier_id, null, DemandsEO.USING_ASSEMBLY_DEMAND_DATE, DemandsEO.SCHEDULE_SHIP_DATE) is null and decode(DemandsEO.supplier_id, null, DemandsEO.SCHEDULE_ARRIVAL_DATE, DemandsEO.USING_ASSEMBLY_DEMAND_DATE) is null then 2 else 1 end) AS Scheduling_Status_Code, BMRUNEO.ECC_FLAG, BMRUNEO.PULL_IN_FLAG, BMRUNEO.MANUAL_OVERRIDE_FLAG, BMRUNEO.EXPECTED_SHIP_METHOD as EXPECTED_SHIP_METHOD_ID, BMRUNEO.EXPECTED_CARRIER_ID as EXPECTED_CARRIER_ID, BMRUNEO.EXPECTED_SERVICE_LEVEL as EXPECTED_SERVICE_LEVEL_ID, BMRUNEO.EXPECTED_SUPPLIER_ID as EXPECTED_SUPPLIER_ID, BMRUNEO.EXPECTED_MODE_OF_TRANSPORT as EXPECTED_MODE_OF_TRANSPORT_ID, BMRUNEO.EXPECTED_SUPPLIER_SITE_ID as EXPECTED_SUPPLIER_SITE_ID, BMRUNEO.SOURCE_ORGANIZATION_ID as EXPECTED_ORGANIZATION_ID, (select msc_get_name.org_code(BMRUNEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WAREHOUSE, (select msc_get_name.org_name(BMRUNEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WARE_NAME, (select msc_get_name.supplier(BMRUNEO.EXPECTED_SUPPLIER_ID) from dual) AS EXPECTED_DSHIP_SUPPLIER, (select msc_get_name.supplier_site(BMRUNEO.EXPECTED_SUPPLIER_SITE_ID) from dual) AS EXPECTED_DSHIP_SUPP_SITE, (select msc_get_name.carrier_name(BMRUNEO.EXPECTED_CARRIER_ID) from dual) AS EXPECTED_CARRIER, DemandsEO.DEMAND_ID, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.BASE_DEMAND_ID,DemandsEO.DEMAND_ID) AS BASE_DEMAND_ID, DemandsEO.CUSTOMER_ID, NVL(DemandsEO.CUSTOMER_SITE_ID, DemandsEO.SHIP_TO_SITE_ID) AS CUSTOMER_SITE_ID, DemandsEO.DEMAND_CLASS, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.DEMAND_CLASS, 'DEMAND_CLASS') from dual) AS DEMAND_CLASS_CODE, DemandsEO.SELLING_PRICE, DemandsEO.ORCH_ORDER_HEADER_ID, DemandsEO.ORCH_ORDER_LINE_ID, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.CARRIER_ID,DemandsEO.CARRIER_ID) AS CARRIER_ID, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.MODE_OF_TRANSPORT,DemandsEO.MODE_OF_TRANSPORT) AS MODE_OF_TRANSPORT, DemandsEO.RESERVATION_ID, DECODE(DemandsEO.origination_type, 1030, NVL((select msc_get_name.get_demand_reserved_quantity(DemandsEO.sales_order_line_id, DemandsEO.organization_id) from dual),DemandsEO.reserved_quantity), DemandsEO.reserved_quantity) AS RESERVED_QUANTITY, DemandsEO.PLANNED_SHIP_DATE, (select msc_bm_common.item_name(DemandsEO.INVENTORY_ITEM_ID,DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id) ,-1) from dual) AS ITEM, (select msc_bm_common.item_desc(DemandsEO.INVENTORY_ITEM_ID,DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id) ,-1) from dual) AS ITEM_DESCRIPTION, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.ORGANIZATION_ID,DemandsEO.ORGANIZATION_ID) AS ORGANIZATION_ID, DemandsEO.ORGANIZATION_ID AS SCHEDULED_SHIP_FROM_ORG_ID, (select msc_bm_common.get_ship_model_complete_flag(DemandsEO.INVENTORY_ITEM_ID) from dual) AS SHIP_MODEL_COMPLETE_FLAG, DemandsEO.ORIGINAL_ITEM_ID, DemandsEO.RECEIVING_ORG_ID, DemandsEO.CONFIGURED_ITEM AS CONFIGURATION_ITEM, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.SUPPLIER_ID,DemandsEO.SUPPLIER_ID) AS SUPPLIER_ID, DemandsEO.SUPPLIER_ID AS SCHEDULED_SUPPLIER_ID, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.SUPPLIER_SITE_ID,DemandsEO.SUPPLIER_SITE_ID) AS SUPPLIER_SITE_ID, DemandsEO.SUPPLIER_SITE_ID AS SCHEDULED_SUPPLIER_SITE_ID, DemandsEO.USING_REQUIREMENT_QUANTITY, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.SERVICE_LEVEL,DemandsEO.SERVICE_LEVEL) AS SERVICE_LEVEL, DemandsEO.LATEST_ACCEPTABLE_SHIP_DATE, DemandsEO.LATEST_ACCEPTABLE_ARRIVAL_DATE, DemandsEO.EARLIEST_ACCEPT_SHIP_DATE, DemandsEO.EARLIEST_ACCEPT_ARRIVAL_DATE, nvl( DemandsEO.ORDER_DATE_TYPE_CODE,1) AS ORDER_DATE_TYPE_CODE, nvl(DemandsEO.SHIPPING_METHOD_CODE,DemandsEO.SHIP_METHOD) as SHIP_METHOD, nvl(DemandsEO.SHIPPING_METHOD_CODE,DemandsEO.SHIP_METHOD) AS REQUESTED_SHIP_METHOD, ( CASE WHEN (DemandsEO. supplier_id IS NOT NULL) THEN DemandsEO.USING_ASSEMBLY_DEMAND_DATE ELSE DemandsEO.SCHEDULE_ARRIVAL_DATE END) AS Schedule_Arrival_Date, DemandsEO.USING_ASSEMBLY_DEMAND_DATE, DemandsEO.ZONE_ID, (Case when (BMRUNEO.bm_run_id is not null) then BMRUNEO.BM_ROOT_FULFILLMENT_LINE else DemandsEO.ROOT_FULFILLMENT_LINE END) AS ROOT_FULFILLMENT_LINE, NVL(DemandsEO.SHIP_SET_ID,DemandsEO.ARRIVAL_SET_ID) AS SHIP_SET_ID, NVL(DemandsEO.SHIP_SET_NAME,DemandsEO.ARRIVAL_SET_NAME) AS SHIP_SET_NAME, NVL(DemandsEO.SHIP_SET_ID,DemandsEO.ARRIVAL_SET_ID) AS ORIGINAL_SHIP_SET_ID, NVL(DemandsEO.SHIP_SET_NAME,DemandsEO.ARRIVAL_SET_NAME) AS ORIGINAL_SHIP_SET_NAME, ( CASE when (BMRUNEO.bm_run_id is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is null) then null else case WHEN DemandsEO.SHIP_SET_NAME IS NOT NULL THEN 1 WHEN DemandsEO.ARRIVAL_SET_NAME IS NOT NULL THEN 2 end END) AS SET_TYPE, DemandsEO.SALES_ORDER_PRIORITY AS ORIGINAL_PRIORITY, DemandsEO.SALES_ORDER_LINE_SPLIT, DemandsEO.ISSUED_QUANTITY, ( CASE when (BMRUNEO.bm_run_id is not null and demandsEO.using_requirement_quantity is not null and demandsEO.using_requirement_quantity!=0 and BMRUNEO.REQUESTED_QUANTITY!=demandsEO.using_requirement_quantity) then ((BMRUNEO.REQUESTED_QUANTITY/demandsEO.using_requirement_quantity) * (DemandsEO.fulfillment_cost)) else DemandsEO.FULFILLMENT_COST END) AS FULFILLMENT_COST, DemandsEO.SHIPPING_PREFERENCE, msc_bm_common.get_unit_of_measure(DEMANDSEO.INVENTORY_ITEM_ID,DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.ORGANIZATION_ID,DemandsEO.ORGANIZATION_ID)) AS UOM_CODE, DemandsEO.ORDERED_UOM, (case when DemandsEO.ORDERED_UOM = msc_bm_common.get_uom_code(DEMANDSEO.INVENTORY_ITEM_ID,DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.ORGANIZATION_ID,DemandsEO.ORGANIZATION_ID)) then 1 else (select msc_gopui_util.uom_conversion_rate(DemandsEO.INVENTORY_ITEM_ID,null,DemandsEO.ORDERED_UOM) from dual) end) as UOM_RATE, DemandsEO.SALES_ORDER_NUMBER, DemandsEO.SO_LINE_NUM, ( CASE WHEN (DemandsEO.orch_order_header_id IS NOT NULL) THEN nvl(DemandsEO.orch_order_number,DemandsEO.sales_order_number) ELSE DemandsEO.sales_order_number END) AS Order_Number, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.latest_acceptable_ship_date, 2, demandsEO.latest_acceptable_arrival_date) AS Latest_Acceptable_Date, (select msc_bm_common.get_bom_item_type(DemandsEO.INVENTORY_ITEM_ID) from dual) AS BOM_ITEM_TYPE, (select msc_get_name.lookup_meaning('ORA_MSC_BOM_ITEM_TYPE',(select msc_bm_common.get_bom_item_type(DemandsEO.INVENTORY_ITEM_ID) from dual)) from dual) AS Bom_item_type_code, (select msc_bm_common.get_item_Sub_Type_code(DemandsEO.item_sub_type_code,DemandsEO.INVENTORY_ITEM_ID) from dual) AS Item_Sub_Type_code, ( CASE WHEN (demandsEO.orch_order_header_id IS NULL AND demandsEO.orch_order_line_id IS NULL) THEN 1 WHEN (demandsEO.orch_order_header_id IS NOT NULL AND demandsEO.orch_order_line_id IS NOT NULL) THEN 2 END) AS Order_Type_Code, DECODE (demandsEO.order_date_type_code, 1, demandsEO.request_date, NULL) AS Request_Ship_Date, ( CASE WHEN (DemandsEO. supplier_id IS NOT NULL) 次に、DemandsEOを実行します。 SCHEDULE_SHIP_DATE ELSE DemandsEO.USING_ASSEMBLY_DEMAND_DATE END) AS Schedule_Ship_Date, (Case when (BMRUNEO.bm_run_id is not null) then BMRUNEO.BM_SALES_ORDER_LINE_ID else demandsEO.sales_order_line_id END) AS Sales_Order_Line_Id, case when ((select msc_bm_common.get_reservation_status(demandsEO.sales_order_line_id) from dual) is not null) then 1 else 2 END AS RESERVATION_STATUS_VALUE, ( CASE when (BMRUNEO.bm_run_id is not null and BMRUNEO.REQUESTED_QUANTITY=demandsEO.using_requirement_quantity) then ((BMRUNEO.REQUESTED_QUANTITY*demandsEO.selling_price) - NVL(DemandsEO.fulfillment_cost,0)) when (BMRUNEO.bm_run_id is not null and demandsEO.using_requirement_quantity is not null and demandsEO.using_requirement_quantity!=0 and BMRUNEO.REQUESTED_QUANTITY!=demandsEO.using_requirement_quantity) then ((BMRUNEO.REQUESTED_QUANTITY*demandsEO.selling_price) - nvl(((BMRUNEO.REQUESTED_QUANTITY/demandsEO.using_requirement_quantity) * (DemandsEO.fulfillment_cost)),0)) else ((demandsEO.using_requirement_quantity*demandsEO.selling_price) - NVL(DemandsEO.fulfillment_cost,0)) END) AS ORDER_MARGIN, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.earliest_accept_ship_date, 2, demandsEO.earliest_accept_arrival_date) AS Earliest_Acceptable_Date, NVL(demandsEO.promise_arrival_date,DECODE(demandsEO.order_date_type_code,2,demandsEO.promise_date ,NULL)) AS Promised_Arrival_Date, NVL(demandsEO.promise_ship_date,DECODE (demandsEO.order_date_type_code, 1, demandsEO.promise_date , NULL)) AS Promised_Ship_Date, DECODE (demandsEO.order_date_type_code, 2, demandsEO.request_date, NULL) AS Requested_Arrival_Date, (select msc_bm_common.item_name(DemandsEO.INVENTORY_ITEM_ID,DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id) ,-1) from dual) AS SCHEDULED_ITEM, (select msc_bm_common.item_desc(DemandsEO.INVENTORY_ITEM_ID,DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id) ,-1) from dual) AS SCHEDULED_ITEM_DESCRIPTION, ( CASE WHEN (BMRunEO.bm_run_id IS NOT NULL) THEN BMRunEO.order_line_number WHEN (DemandsEO.orch_order_header_id IS NOT NULL) THEN DemandsEO.orch_order_line_number ||'.' ||TO_CHAR(DemandsEO.Fulfillment_line_num) ELSE DemandsEO.so_line_num END) AS Order_Line_Number, ItemCategoryEO.CATEGORY_NAME, ItemCategoryEO.CATEGORY_NAME as NAME_OF_CATEGORY, ItemCategoryEO.CATALOG_NAME, (select msc_get_name.org_name(DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id)) from dual) AS ORGANIZATION_NAME, (select msc_get_name.org_code(DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id)) from dual) AS ORGANIZATION, (select msc_get_name.org_code(DemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WAREHOUSE, (select msc_get_name.org_name(DemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WARE_NAME, ( CASE WHEN (demandsEO.orch_order_header_id IS NULL AND demandsEO.orch_order_line_id IS NULL) THEN (select msc_get_name.lookup_meaning('ORA_MSC_OP_ORDER_TYPE',1) from dual) WHEN (demandsEO.orch_order_header_id IS NOT NULL AND demandsEO.orch_order_line_id IS NOT NULL) THEN (select msc_get_name.lookup_meaning('ORA_MSC_OP_ORDER_TYPE',2) from dual) END) AS Order_Type, DemandsEO.REQUEST_DATE, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE) AS Schedule_Date, TRUNC(DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE))- TRUNC(demandsEO.request_date) AS days_late, ( CASE when (BMRUNEO.bm_run_id is not null) then BMRUNEO.ORDER_REVENUE else (demandsEO.using_requirement_quantity*demandsEO.selling_price) END) AS ORDER_REVENUE, DemandsEO.ORIGINAL_ORG_ID, DemandsEO.DEMAND_TYPE, DemandsEO.USING_ASSEMBLY_ITEM_ID, DemandsEO.ORIGINAL_QUANTITY, (DemandsEO.source_org_instance_id) AS SOURCE_ORG_INSTANCE_ID, (select msc_gopui_util.get_instance_code(DemandsEO.PART_KEY1) from dual) AS DEMAND_SOURCE_INSTANCE, DemandsEO.ALLOW_SPLITS, DemandsEO.ALLOW_SUBSTITUTION, DemandsEO.FULFILLMENT_LINE_NUM, DemandsEO.MIN_PERCENTAGE_FOR_SPLIT, DemandsEO.MIN_QUANTITY_FOR_SPLIT, DemandsEO.ORCH_ORDER_LINE_NUMBER, DemandsEO.ORCH_ORDER_NUMBER, DemandsEO.PROMISE_DATE, DemandsEO.PROMISING_SYSTEM, DemandsEO.COMPLETED_QUANTITY, DemandsEO.DEMAND_SOURCE_TYPE, DECODE(DemandsEO.DEMAND_SOURCE_TYPE, 1, DemandsEO.SOURCE_DOCUMENT_LINE_NUMBER, so_line_num) AS SOURCE_DOCUMENT_LINE_NUMBER, DECODE(DemandsEO.DEMAND_SOURCE_TYPE, 1, DemandsEO.SOURCE_DOCUMENT_NUMBER, sales_order_number) AS SOURCE_DOCUMENT_NUMBER, DemandsEO.PART_KEY1 as DEMAND_SOURCE_SYSTEM_ID, DemandsEO.INVENTORY_ITEM_ID, ItemCategoryEO.CATEGORY_ID, ItemCategoryEO.CATEGORY_SET_ID, Case when (BMRUNEO.bm_run_id is not null and BMRUNEO.BM_PARENT_FULFILLMENT_LINE is null) then null when (BMRUNEO.bm_run_id is not null and BMRUNEO.BM_PARENT_FULFILLMENT_LINE is not null and TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) !='-23453' and (TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) = BMRUNEO.BM_sales_order_line_id)) then null when (BMRUNEO.bm_run_id is not null and BMRUNEO.BM_PARENT_FULFILLMENT_LINE is not null and TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) !='-23453' and (TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) != BMRUNEO.BM_sales_order_line_id)) then TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) when (BMRUNEO.bm_run_id is not null and BMRUNEO.BM_PARENT_FULFILLMENT_LINE is not null and TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) ='-23453' ) then null when (BMRUNEO.bm_run_id is null and DemandsEO.PARENT_FULFILLMENT_LINE is not null) Then Case when (TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) = sales_order_line_id) Then null else TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) end else TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) end AS PARENT_FULFILLMENT_LINE, CASE WHEN (DemandsEO.PARENT_FULFILLMENT_LINE IS NULL OR TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) = sales_order_line_id) AND (DemandsEO.ship_set_name IS NOT NULL OR DemandsEO.arrival_set_name IS NOT NULL) and (BMRUNEO.bm_run_id is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is not null or BMRunEO.bm_run_id is null) THEN CASE WHEN (DemandsEO.orch_order_header_id IS NOT NULL) THEN nvl(DemandsEO.orch_order_number,DemandsEO.sales_order_number) || ':' || NVL(DemandsEO.ship_set_name,DemandsEO.Arrival_set_name) else DemandsEO.sales_order_number || ':' || NVL(DemandsEO.ship_set_name,DemandsEO.Arrival_set_name) end else case WHEN (DemandsEO.PARENT_FULFILLMENT_LINE IS NOT NULL) THEN CASE WHEN (TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) = sales_order_line_id) THEN NULL ELSE TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) END ELSE TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) end end AS SET_PARENT_FULFILLMENT_LINE, sales_order_line_id AS Fulfillment_line, (select msc_get_name.customer(DemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NAME, (select msc_get_name.customer_number(DemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NUMBER, (select msc_get_name.customer_site(DemandsEO.CUSTOMER_SITE_ID) from dual) AS CUSTOMER_SHIP_SITE, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.REQUESTED_QUANTITY,DemandsEO.Using_REQUIREMENT_QUANTITY) AS REQUESTED_QUANTITY, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.REQUESTED_QUANTITY,DemandsEO.Using_REQUIREMENT_QUANTITY) AS SCHEDULED_QUANTITY, (select msc_get_name.supplier(DemandsEO.SUPPLIER_ID) from dual) AS SCHEDULED_DROPSHIP_SUPPLIER, (select msc_get_name.supplier_site(DemandsEO.SUPPLIER_SITE_ID) from dual) AS SCHEDULED_DROPSHIP_SUP_SITE, CASE WHEN (DemandsEO.supplier_id is not null) Then (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',2) from dual) ELSE decode ((select msc_bm_common.get_back_to_back_flag(DemandsEO.INVENTORY_ITEM_ID) from dual), 1, (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',3) from dual), (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',1) from dual)) END AS FULFILLMENT_MODE, (select msc_get_name.carrier_name(DemandsEO.CARRIER_ID) from dual) AS SCHEDULED_CARRIER, TRUNC(DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE))- TRUNC(demandsEO.request_date) AS Scheduled_days_of_Delays, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS SCHEDULED_MODE_OF_TRANSPORT, (select msc_get_name.msc_sr_lookup_meaning(BMRUNEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS EXPECTED_MODE_OF_TRANSPORT, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS SCHEDULED_SERVICE_LEVEL, (select msc_get_name.msc_sr_lookup_meaning(BMRUNEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS EXPECTED_SERVICE_LEVEL, CASE when (BMRUNEO.MARKED_FOR_RELEASE = 1) then 14 when (BMRUNEO.BM_RUN_ID is not null and (BMRUNEO.MARKED_FOR_RELEASE is null or BMRUNEO.MARKED_FOR_RELEASE != 1)) then BMRUNEO.release_status else DemandsEO.release_status END as release_status, CASE when (BMRUNEO.BM_RUN_ID is not null ) then BMRUNEO.release_status else DemandsEO.release_status END as release_status_orig, (select MSC_SPUI_COMMON.planner_code(DEMANDSEO.INVENTORY_ITEM_ID,DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.ORGANIZATION_ID,DemandsEO.ORGANIZATION_ID),-1) from dual) AS PLANNER_CODE, 1 AS Object_Version_Number, DemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID, DemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID AS SCHED_SUP_SITE_SYSTEM_ID, (select msc_gopui_util.get_instance_code(supplier_site_source_system_id) from dual) AS SCHED_SUP_SITE_SYSTEM, CASE WHEN (DEMANDSEO.demand_source_type = 1 AND DEMANDSEO.expense_transfer = 1) THEN 'TOE' WHEN (DEMANDSEO.demand_source_type = 1 AND (DEMANDSEO.expense_transfer = 2 OR DEMANDSEO.expense_transfer IS NULL )) THEN 'TO' WHEN (DEMANDSEO.demand_source_type = 8 AND DEMANDSEO.expense_transfer = 1) THEN 'ISOE' WHEN (DEMANDSEO.demand_source_type = 8 AND (DEMANDSEO.expense_transfer = 2 OR DEMANDSEO.expense_transfer IS NULL )) THEN 'ISO' END AS INTERNAL_ORDER_TYPE, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.LAST_UPDATED_BY,DemandsEO.LAST_UPDATED_BY) AS LAST_UPDATED_BY, DECODE(BMRUNEO.BM_RUN_ID, -1,BMRUNEO.LAST_UPDATE_DATE,DemandsEO.LAST_UPDATE_DATE) AS LAST_UPDATE_DATE, DemandsEO.SET_HEADER_NAME as SET_HEADER_NAME, 2 as ROW_TYPE, DECODE(BMRUNEO.BM_RUN_ID, -1,null,BMRUNEO.OVERRIDE_PRIORITY) AS OVERRIDE_PRIORITY, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, BMRUNEO.EXPECTED_SHIP_DATE, 2, BMRUNEO.EXPECTED_ARRIVAL_DATE, BMRUNEO.EXPECTED_SHIP_DATE) AS EXPECTED_DATE, BMRUNEO.REQUESTED_DATE, null as MODIFIED, DemandsEO.ORDERED_DATE AS creation_date, nvl(DemandsEO.INQUIRY_DEMAND,2) AS INQUIRY_DEMAND, DEMANDSEO.expense_transfer, ( CASE WHEN (DemandsEO.demand_source_type=1 OR DemandsEO.demand_source_type =8) THEN (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE',94) from dual) ELSE (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE',1030) from dual) END) AS SOURCE_DOC_ORDER_TYPE_STR, case when (BMRUNEO.bm_run_id is not null and NVL(DemandsEO.SHIP_SET_NAME,DemandsEO.ARRIVAL_SET_NAME) is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is null ) then 1 else 2 end AS removed_from_set, DemandsEO.order_line_status, BMRunEO.CONSTRAINT_RANK, BMRunEO.DAYS_POTENTIALLY_IMPROVE, BMRunEO.PLANNED_DATE_WITHOUT_ITEM, BMRunEO.SPLIT_INDICATOR, DemandsEO.PARENT_FULFILLMENT_LINE AS ORIG_PARENT_FUL_LINE, DemandsEO.ATTRIBUTE_CATEGORY, DemandsEO.ATTRIBUTE_CHAR1, DemandsEO.ATTRIBUTE_CHAR2, DemandsEO.ATTRIBUTE_CHAR3, DemandsEO.ATTRIBUTE_CHAR4, DemandsEO.ATTRIBUTE_CHAR5, DemandsEO.ATTRIBUTE_CHAR6, DemandsEO.ATTRIBUTE_CHAR7, DemandsEO.ATTRIBUTE_CHAR8, DemandsEO.ATTRIBUTE_CHAR9, DemandsEO.ATTRIBUTE_CHAR10, DemandsEO.ATTRIBUTE_CHAR11, DemandsEO.ATTRIBUTE_CHAR12, DemandsEO.ATTRIBUTE_CHAR13, DemandsEO.ATTRIBUTE_CHAR14, DemandsEO.ATTRIBUTE_CHAR15, DemandsEO.ATTRIBUTE_CHAR16, DemandsEO.ATTRIBUTE_CHAR17, DemandsEO.ATTRIBUTE_CHAR18, DemandsEO.ATTRIBUTE_CHAR19, DemandsEO.ATTRIBUTE_CHAR20, DemandsEO.ATTRIBUTE_NUMBER1, DemandsEO.ATTRIBUTE_NUMBER2, DemandsEO.ATTRIBUTE_NUMBER3, DemandsEO.ATTRIBUTE_NUMBER4, DemandsEO.ATTRIBUTE_NUMBER5, DemandsEO.ATTRIBUTE_NUMBER6, DemandsEO.ATTRIBUTE_NUMBER7, DemandsEO.ATTRIBUTE_NUMBER8, DemandsEO.ATTRIBUTE_NUMBER9, DemandsEO.ATTRIBUTE_NUMBER10, DemandsEO.ATTRIBUTE_DATE1, DemandsEO.ATTRIBUTE_DATE2, DemandsEO.ATTRIBUTE_DATE3, DemandsEO.ATTRIBUTE_DATE4, DemandsEO.ATTRIBUTE_DATE5, DemandsEO.ATTRIBUTE_DATE6, DemandsEO.ATTRIBUTE_DATE7, DemandsEO.ATTRIBUTE_DATE8, DemandsEO.ATTRIBUTE_DATE9, DemandsEO.ATTRIBUTE_DATE10, DemandsEO.ATTRIBUTE_DATE11, DemandsEO.ATTRIBUTE_DATE12, DemandsEO.ATTRIBUTE_DATE13, DemandsEO.ATTRIBUTE_DATE14, DemandsEO.ATTRIBUTE_DATE15, DemandsEO.ATTRIBUTE_DATE16, DemandsEO.ATTRIBUTE_DATE17, DemandsEO.ATTRIBUTE_DATE18, DemandsEO.ATTRIBUTE_DATE19, DemandsEO.ATTRIBUTE_DATE20, DemandsEO.GLOBAL_ATTRIBUTE_CHAR1, DemandsEO.GLOBAL_ATTRIBUTE_CHAR2, DemandsEO.GLOBAL_ATTRIBUTE_CHAR3, DemandsEO.GLOBAL_ATTRIBUTE_CHAR4, DemandsEO.GLOBAL_ATTRIBUTE_CHAR5, DemandsEO.GLOBAL_ATTRIBUTE_CHAR6, DemandsEO.GLOBAL_ATTRIBUTE_CHAR7, DemandsEO.GLOBAL_ATTRIBUTE_CHAR8, DemandsEO.GLOBAL_ATTRIBUTE_CHAR9, DemandsEO.GLOBAL_ATTRIBUTE_CHAR10, DemandsEO.GLOBAL_ATTRIBUTE_CHAR11, DemandsEO.GLOBAL_ATTRIBUTE_CHAR12, DemandsEO.GLOBAL_ATTRIBUTE_CHAR13, DemandsEO.GLOBAL_ATTRIBUTE_CHAR14, DemandsEO.GLOBAL_ATTRIBUTE_CHAR15, DemandsEO.GLOBAL_ATTRIBUTE_CHAR16, DemandsEO.GLOBAL_ATTRIBUTE_CHAR17, DemandsEO.GLOBAL_ATTRIBUTE_CHAR18, DemandsEO.GLOBAL_ATTRIBUTE_CHAR19, DemandsEO.GLOBAL_ATTRIBUTE_CHAR20, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER1, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER2, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER3, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER4, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER5, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER6, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER7, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER8, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER9, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER10, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER11, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER12, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER13, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER14, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER15, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER16, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER17, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER18, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER19, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER20, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER21, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER22, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER23, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER24, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER25, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER26, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER27, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER28, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER29, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER30, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER31, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER32, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER33, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER34, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER35, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER36, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER37, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER38, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER39, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER40, DemandsEO.GLOBAL_ATTRIBUTE_DATE1, DemandsEO.GLOBAL_ATTRIBUTE_DATE2, DemandsEO.GLOBAL_ATTRIBUTE_DATE3, DemandsEO.GLOBAL_ATTRIBUTE_DATE4, DemandsEO.GLOBAL_ATTRIBUTE_DATE5, DemandsEO.GLOBAL_ATTRIBUTE_DATE6, DemandsEO.GLOBAL_ATTRIBUTE_DATE7, DemandsEO.GLOBAL_ATTRIBUTE_DATE8, DemandsEO.GLOBAL_ATTRIBUTE_DATE9, DemandsEO.GLOBAL_ATTRIBUTE_DATE10, DemandsEO.GLOBAL_ATTRIBUTE_DATE11, DemandsEO.GLOBAL_ATTRIBUTE_DATE12, DemandsEO.GLOBAL_ATTRIBUTE_DATE13, DemandsEO.GLOBAL_ATTRIBUTE_DATE14, DemandsEO.GLOBAL_ATTRIBUTE_DATE15, DemandsEO.GLOBAL_ATTRIBUTE_DATE16, DemandsEO.GLOBAL_ATTRIBUTE_DATE17, DemandsEO.GLOBAL_ATTRIBUTE_DATE18, DemandsEO.GLOBAL_ATTRIBUTE_DATE19, DemandsEO.GLOBAL_ATTRIBUTE_DATE20 FROM MSC_DEMANDS DemandsEO, MSC_BM_RUN_DEMANDS BMRunEO, (SELECT CategoryEO.CATEGORY_ID, CategoryEO.CATEGORY_SET_ID, CategoryEO.CATEGORY_NAME, ItemCategoriesEO.inventory_item_id, ItemCategoriesEO.organization_id, SetEO.CATEGORY_SET_NAME as CATALOG_NAME FROM MSC_CATALOG_CATEGORIES CategoryEO, MSC_ITEM_CATEGORIES ItemCategoriesEO, MSC_CATEGORY_SETS SetEO WHERE CategoryEO.category_set_id = NVL(fnd_profile.value('MSC_SRC_ASSIGNMENT_CATALOG'),2) AND CategoryEO.category_id = ItemCategoriesEO.category_id AND CategoryEO.category_set_id = SetEO.category_set_id )ItemCategoryEO WHERE DemandsEO.plan_id = -1 AND DemandsEO.origination_type = 1030 AND DemandsEO.plan_id = BMRunEO.bm_run_id(+) AND DemandsEO.demand_id = BMRunEO.demand_id(+) AND ItemCategoryEO.organization_id(+) = DECODE(BMRunEO.BM_RUN_ID,-1,BMRunEO.organization_id,DemandsEO.organization_id) AND ItemCategoryEO.inventory_item_id(+) = DemandsEO.inventory_item_id AND DemandsEO.REQUEST_DATE IS NOT NULL AND ((DEMANDSEO.expense_transfer IS NULL OR DEMANDSEO.expense_transfer =2) OR (DEMANDSEO.expense_transfer =1 AND DEMANDSEO.interfaced_to_doo =1)) union all SELECT BMRUNEO.BM_RUN_ID, nvl(BMRUNEO.USR_DEF_DMD_LEAD_TIME_DATE,BMRUNEO.DEMAND_LEAD_TIME_DATE) AS DEMAND_LEAD_TIME_DATE, BMRUNEO.USR_DEF_DMD_LEAD_TIME_DATE, BMRUNEO.DEMAND_FULFILLMENT_LEAD_TIME AS DEMAND_FULFILLMENT_LEAD_TIME, BMRUNEO.REASON_CODE, BMRUNEO.DEMAND_PRIORITY, BMRUNEO.NEW_PROMISED_DATE, BMRUNEO.OLD_PROMISED_DATE, BMRUNEO.SOURCE_ORGANIZATION_ID, BMRUNEO.FIRM_SALES_ORDER, BMRUNEO.FIRM_SHIP_FROM_ORG, BMRUNEO.FIRM_SHIP_SET_NAME, BMRUNEO.FIRM_ARRIVAL_SET_NAME, BMRUNEO.EARLIEST_PROMISED_DATE, BMRUNEO.EXPECTED_SHIP_DATE, BMRUNEO.EXPECTED_ARRIVAL_DATE, ( case when decode(DemandsEO.supplier_id, null, DemandsEO.USING_ASSEMBLY_DEMAND_DATE, DemandsEO.SCHEDULE_SHIP_DATE) is null and decode(DemandsEO.supplier_id, null, DemandsEO.SCHEDULE_ARRIVAL_DATE, DemandsEO.USING_ASSEMBLY_DEMAND_DATE) is null then 2 else 1 end) AS Scheduling_Status_Code, BMRUNEO.ECC_FLAG, BMRUNEO.PULL_IN_FLAG, BMRUNEO.MANUAL_OVERRIDE_FLAG, BMRUNEO.EXPECTED_SHIP_METHOD as EXPECTED_SHIP_METHOD_ID, BMRUNEO.EXPECTED_CARRIER_ID as EXPECTED_CARRIER_ID, BMRUNEO.EXPECTED_SERVICE_LEVEL as EXPECTED_SERVICE_LEVEL_ID, BMRUNEO.EXPECTED_SUPPLIER_ID as EXPECTED_SUPPLIER_ID, BMRUNEO.EXPECTED_MODE_OF_TRANSPORT as EXPECTED_MODE_OF_TRANSPORT_ID, BMRUNEO.EXPECTED_SUPPLIER_SITE_ID as EXPECTED_SUPPLIER_SITE_ID, BMRUNEO.SOURCE_ORGANIZATION_ID as EXPECTED_ORGANIZATION_ID, (select msc_get_name.org_code(BMRUNEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WAREHOUSE, (select msc_get_name.org_name(BMRUNEO.SOURCE_ORGANIZATION_ID) from dual) AS EXPECTED_SHIP_FROM_WARE_NAME, (select msc_get_name.supplier(BMRUNEO.EXPECTED_SUPPLIER_ID) from dual) AS EXPECTED_DSHIP_SUPPLIER, (select msc_get_name.supplier_site(BMRUNEO.EXPECTED_SUPPLIER_SITE_ID) from dual) AS EXPECTED_DSHIP_SUPP_SITE, (select msc_get_name.carrier_name(BMRUNEO.EXPECTED_CARRIER_ID) from dual) AS EXPECTED_CARRIER, BMRUNEO.DEMAND_ID, BMRUNEO.BASE_DEMAND_ID, DemandsEO.CUSTOMER_ID, NVL(DemandsEO.CUSTOMER_SITE_ID, DemandsEO.SHIP_TO_SITE_ID) AS CUSTOMER_SITE_ID, DemandsEO.DEMAND_CLASS, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.DEMAND_CLASS, 'DEMAND_CLASS') from dual) AS DEMAND_CLASS_CODE, DemandsEO.SELLING_PRICE, DemandsEO.ORCH_ORDER_HEADER_ID, DemandsEO.ORCH_ORDER_LINE_ID, BMRUNEO.CARRIER_ID AS CARRIER_ID, BMRUNEO.MODE_OF_TRANSPORT AS MODE_OF_TRANSPORT, DemandsEO.RESERVATION_ID, null RESERVED_QUANTITY, DemandsEO.PLANNED_SHIP_DATE, (select msc_bm_common.item_name(BMRunEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID ,-1) from dual) AS ITEM, (select msc_bm_common.item_desc(BMRunEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID ,-1) from dual) AS ITEM_DESCRIPTION, BMRUNEO.ORGANIZATION_ID AS ORGANIZATION_ID, DemandsEO.ORGANIZATION_ID AS SCHEDULED_SHIP_FROM_ORG_ID, (select msc_bm_common.get_ship_model_complete_flag(BMRUNEO.INVENTORY_ITEM_ID) from dual) AS SHIP_MODEL_COMPLETE_FLAG, DemandsEO.ORIGINAL_ITEM_ID, DemandsEO.RECEIVING_ORG_ID, DemandsEO.CONFIGURED_ITEM AS CONFIGURATION_ITEM, BMRUNEO.SUPPLIER_ID AS SUPPLIER_ID, DemandsEO.SUPPLIER_ID AS SCHEDULED_SUPPLIER_ID, BMRUNEO.SUPPLIER_SITE_ID AS SUPPLIER_SITE_ID, DemandsEO.SUPPLIER_SITE_ID AS SCHEDULED_SUPPLIER_SITE_ID, DemandsEO.USING_REQUIREMENT_QUANTITY, BMRUNEO.SERVICE_LEVEL AS SERVICE_LEVEL, DemandsEO.LATEST_ACCEPTABLE_SHIP_DATE, DemandsEO.LATEST_ACCEPTABLE_ARRIVAL_DATE, DemandsEO.EARLIEST_ACCEPT_SHIP_DATE, DemandsEO.EARLIEST_ACCEPT_ARRIVAL_DATE, nvl( DemandsEO.ORDER_DATE_TYPE_CODE,1) AS ORDER_DATE_TYPE_CODE, nvl(DemandsEO.SHIPPING_METHOD_CODE,DemandsEO.SHIP_METHOD) as SHIP_METHOD, nvl(DemandsEO.SHIPPING_METHOD_CODE,DemandsEO.SHIP_METHOD) AS REQUESTED_SHIP_METHOD, ( CASE WHEN (DemandsEO. supplier_id IS NOT NULL) THEN DemandsEO.USING_ASSEMBLY_DEMAND_DATE ELSE DemandsEO.SCHEDULE_ARRIVAL_DATE END) AS Schedule_Arrival_Date, DemandsEO.USING_ASSEMBLY_DEMAND_DATE, DemandsEO.ZONE_ID, BMRUNEO.BM_ROOT_FULFILLMENT_LINE as ROOT_FULFILLMENT_LINE, NVL(DemandsEO.SHIP_SET_ID,DemandsEO.ARRIVAL_SET_ID) AS SHIP_SET_ID, NVL(DemandsEO.SHIP_SET_NAME,DemandsEO.ARRIVAL_SET_NAME) AS SHIP_SET_NAME, NVL(DemandsEO.SHIP_SET_ID,DemandsEO.ARRIVAL_SET_ID) AS ORIGINAL_SHIP_SET_ID, NVL(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) AS ORIGINAL_SHIP_SET_NAME, ( CASE when (BMRUNEO.bm_run_id is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is null) then null else case WHEN DemandsEO.SHIP_SET_NAME IS NOT NULL THEN 1 WHEN DemandsEO.ARRIVAL_SET_NAME IS NOT NULL THEN 2 end END) AS SET_TYPE, DemandsEO.SALES_ORDER_PRIORITY AS ORIGINAL_PRIORITY, DemandsEO.SALES_ORDER_LINE_SPLIT, DemandsEO.ISSUED_QUANTITY, ( CASE when (BMRUNEO.bm_run_id is not null and demandsEO.using_requirement_quantity is not null and demandsEO.using_requirement_quantity!=0 and BMRUNEO.REQUESTED_QUANTITY!=demandsEO.using_requirement_quantity) then ((BMRUNEO.REQUESTED_QUANTITY/demandsEO.using_requirement_quantity) * (DemandsEO.fulfillment_cost)) else DemandsEO.FULFILLMENT_COST END) AS FULFILLMENT_COST, DemandsEO.SHIPPING_PREFERENCE, msc_bm_common.get_unit_of_measure(BMRUNEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID) AS UOM_CODE, DemandsEO.ORDERED_UOM, (case when DemandsEO.ORDERED_UOM = msc_bm_common.get_uom_code(BMRUNEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID) then 1 else (select msc_gopui_util.uom_conversion_rate(BMRUNEO.INVENTORY_ITEM_ID,null,DemandsEO.ORDERED_UOM) from dual) end) as UOM_RATE, DemandsEO.SALES_ORDER_NUMBER, DemandsEO.SO_LINE_NUM, ( CASE WHEN (DemandsEO.orch_order_header_id IS NOT NULL) THEN nvl(DemandsEO.orch_order_number,DemandsEO.sales_order_number) ELSE DemandsEO.sales_order_number END) AS Order_Number, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.latest_acceptable_ship_date, 2, demandsEO.latest_acceptable_arrival_date) AS Latest_Acceptable_Date, (select msc_bm_common.get_bom_item_type(BMRUNEO.INVENTORY_ITEM_ID) from dual) AS BOM_ITEM_TYPE, (select msc_get_name.lookup_meaning('ORA_MSC_BOM_ITEM_TYPE',(select msc_bm_common.get_bom_item_type(BMRUNEO.INVENTORY_ITEM_ID) from dual)) from dual) AS Bom_item_type_code, (select msc_bm_common.get_item_Sub_Type_code(DemandsEO.item_sub_type_code,BMRUNEO.INVENTORY_ITEM_ID) from dual) AS Item_Sub_Type_code, ( CASE WHEN (demandsEO.orch_order_header_id IS NULL AND demandsEO.orch_order_line_id IS NULL) THEN 1 WHEN (demandsEO.orch_order_header_id IS NOT NULL AND demandsEO.orch_order_line_id IS NOT NULL) THEN 2 END) AS Order_Type_Code, DECODE (demandsEO.order_date_type_code, 1, demandsEO.request_date, NULL) AS Request_Ship_Date, ( CASE WHEN (DemandsEO. supplier_id IS NOT NULL) 次に、DemandsEOを実行します。 SCHEDULE_SHIP_DATE ELSE DemandsEO.USING_ASSEMBLY_DEMAND_DATE END) AS Schedule_Ship_Date, BMRunEO.BM_SALES_ORDER_LINE_ID AS Sales_Order_Line_Id, 2 AS RESERVATION_STATUS_VALUE, ( CASE when (BMRUNEO.bm_run_id is not null and demandsEO.using_requirement_quantity is not null and demandsEO.using_requirement_quantity!=0 and BMRUNEO.REQUESTED_QUANTITY!=demandsEO.using_requirement_quantity) then ((BMRUNEO.REQUESTED_QUANTITY*demandsEO.selling_price) - nvl(((BMRUNEO.REQUESTED_QUANTITY/demandsEO.using_requirement_quantity) * (DemandsEO.fulfillment_cost)),0)) else ((BMRUNEO.REQUESTED_QUANTITY*demandsEO.selling_price) - NVL(DemandsEO.fulfillment_cost,0)) END) AS ORDER_MARGIN, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.earliest_accept_ship_date, 2, demandsEO.earliest_accept_arrival_date) AS Earliest_Acceptable_Date, NVL(demandsEO.promise_arrival_date,DECODE(demandsEO.order_date_type_code,2,demandsEO.promise_date ,NULL)) AS Promised_Arrival_Date, NVL(demandsEO.promise_ship_date,DECODE (demandsEO.order_date_type_code, 1, demandsEO.promise_date , NULL)) AS Promised_Ship_Date, DECODE (demandsEO.order_date_type_code, 2, demandsEO.request_date, NULL) AS Requested_Arrival_Date, (select msc_bm_common.item_name(BMRunEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID ,-1) from dual) AS SCHEDULED_ITEM, (select msc_bm_common.item_desc(BMRunEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID ,-1) from dual) AS SCHEDULED_ITEM_DESCRIPTION, BMRUNEO.ORDER_LINE_NUMBER AS Order_Line_Number, ItemCategoryEO.CATEGORY_NAME, ItemCategoryEO.CATEGORY_NAME as NAME_OF_CATEGORY, ItemCategoryEO.CATALOG_NAME, (select msc_get_name.org_name(BMRunEO.organization_id) from dual) AS ORGANIZATION_NAME, (select msc_get_name.org_code(BMRunEO.organization_id) from dual) AS ORGANIZATION, (select msc_get_name.org_code(DemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WAREHOUSE, (select msc_get_name.org_name(DemandsEO.organization_id) from dual) AS SCHEDULED_SHIP_FROM_WARE_NAME, ( CASE WHEN (demandsEO.orch_order_header_id IS NULL AND demandsEO.orch_order_line_id IS NULL) THEN (select msc_get_name.lookup_meaning('ORA_MSC_OP_ORDER_TYPE',1) from dual) WHEN (demandsEO.orch_order_header_id IS NOT NULL AND demandsEO.orch_order_line_id IS NOT NULL) THEN (select msc_get_name.lookup_meaning('ORA_MSC_OP_ORDER_TYPE',2) from dual) END) AS Order_Type, DemandsEO.REQUEST_DATE, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE) AS Schedule_Date, TRUNC(DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE))- TRUNC(demandsEO.request_date) AS days_late, BMRUNEO.Order_Revenue, DemandsEO.ORIGINAL_ORG_ID, DemandsEO.DEMAND_TYPE, DemandsEO.USING_ASSEMBLY_ITEM_ID, DemandsEO.ORIGINAL_QUANTITY, (DemandsEO.source_org_instance_id) AS SOURCE_ORG_INSTANCE_ID, (select msc_gopui_util.get_instance_code(DemandsEO.PART_KEY1) from dual) AS DEMAND_SOURCE_INSTANCE, DemandsEO.ALLOW_SPLITS, DemandsEO.ALLOW_SUBSTITUTION, DemandsEO.FULFILLMENT_LINE_NUM, DemandsEO.MIN_PERCENTAGE_FOR_SPLIT, DemandsEO.MIN_QUANTITY_FOR_SPLIT, DemandsEO.ORCH_ORDER_LINE_NUMBER, DemandsEO.ORCH_ORDER_NUMBER, DemandsEO.PROMISE_DATE, DemandsEO.PROMISING_SYSTEM, DemandsEO.COMPLETED_QUANTITY, DemandsEO.DEMAND_SOURCE_TYPE, DECODE(DemandsEO.DEMAND_SOURCE_TYPE, 1, DemandsEO.SOURCE_DOCUMENT_LINE_NUMBER, so_line_num) AS SOURCE_DOCUMENT_LINE_NUMBER, DECODE(DemandsEO.DEMAND_SOURCE_TYPE, 1, DemandsEO.SOURCE_DOCUMENT_NUMBER, sales_order_number) AS SOURCE_DOCUMENT_NUMBER, DemandsEO.PART_KEY1 as DEMAND_SOURCE_SYSTEM_ID, BMRUNEO.INVENTORY_ITEM_ID, ItemCategoryEO.CATEGORY_ID, ItemCategoryEO.CATEGORY_SET_ID, CASE when (BMRUNEO.bm_run_id is not null and BMRUNEO.BM_PARENT_FULFILLMENT_LINE is null) then null WHEN ( bmruneo.bm_parent_fulfillment_line IS NOT NULL and TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) ='-23453') THEN null WHEN ( bmruneo.bm_parent_fulfillment_line IS NOT NULL and TO_CHAR(BMRUNEO.BM_PARENT_FULFILLMENT_LINE) !='-23453') THEN CASE WHEN ( to_char(bmruneo.bm_parent_fulfillment_line) = bmruneo.bm_sales_order_line_id ) THEN NULL ELSE to_char(bmruneo.bm_parent_fulfillment_line) END END AS parent_fulfillment_line, CASE WHEN (DemandsEO.PARENT_FULFILLMENT_LINE IS NULL OR TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) = sales_order_line_id) AND (DemandsEO.ship_set_name IS NOT NULL OR DemandsEO.arrival_set_name IS NOT NULL) and (BMRUNEO.bm_run_id is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is not null or BMRunEO.bm_run_id is null) THEN CASE WHEN (DemandsEO.orch_order_header_id IS NOT NULL) THEN nvl(DemandsEO.orch_order_number,DemandsEO.sales_order_number) || ':' || NVL(DemandsEO.ship_set_name,DemandsEO.Arrival_set_name) else DemandsEO.sales_order_number || ':' || NVL(DemandsEO.ship_set_name,DemandsEO.Arrival_set_name) end else case WHEN (DemandsEO.PARENT_FULFILLMENT_LINE IS NOT NULL) THEN CASE WHEN (TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) = sales_order_line_id) THEN NULL ELSE TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) END ELSE TO_CHAR(DemandsEO.PARENT_FULFILLMENT_LINE) end end AS SET_PARENT_FULFILLMENT_LINE, sales_order_line_id AS Fulfillment_line, (select msc_get_name.customer(DemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NAME, (select msc_get_name.customer_number(DemandsEO.CUSTOMER_ID) from dual) AS CUSTOMER_NUMBER, (select msc_get_name.customer_site(DemandsEO.CUSTOMER_SITE_ID) from dual) AS CUSTOMER_SHIP_SITE, BMRUNEO.REQUESTED_QUANTITY AS REQUESTED_QUANTITY, BMRUNEO.REQUESTED_QUANTITY AS SCHEDULED_QUANTITY, (select msc_get_name.supplier(DemandsEO.SUPPLIER_ID) from dual) AS SCHEDULED_DROPSHIP_SUPPLIER, (select msc_get_name.supplier_site(DemandsEO.SUPPLIER_SITE_ID) from dual) AS SCHEDULED_DROPSHIP_SUP_SITE, CASE WHEN (DemandsEO.supplier_id is not null) Then (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',2) from dual) ELSE decode ((select msc_bm_common.get_back_to_back_flag(BMRUNEO.INVENTORY_ITEM_ID) from dual), 1, (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',3) from dual), (select msc_get_name.lookup_meaning('ORA_MSC_OP_FULFILLMENT_MODE',1) from dual)) END AS FULFILLMENT_MODE, (select msc_get_name.carrier_name(DemandsEO.CARRIER_ID) from dual) AS SCHEDULED_CARRIER, TRUNC(DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, demandsEO.schedule_ship_date, 2, demandsEO.schedule_arrival_date, demandsEO.USING_ASSEMBLY_DEMAND_DATE))- TRUNC(demandsEO.request_date) AS Scheduled_days_of_Delays, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS SCHEDULED_MODE_OF_TRANSPORT, (select msc_get_name.msc_sr_lookup_meaning(BMRUNEO.mode_of_transport,'WSH_MODE_OF_TRANSPORT') from dual) AS EXPECTED_MODE_OF_TRANSPORT, (select msc_get_name.msc_sr_lookup_meaning(DemandsEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS SCHEDULED_SERVICE_LEVEL, (select msc_get_name.msc_sr_lookup_meaning(BMRUNEO.service_level,'WSH_SERVICE_LEVELS') from dual) AS EXPECTED_SERVICE_LEVEL, CASE when (BMRUNEO.MARKED_FOR_RELEASE = 1) then 14 when (BMRUNEO.BM_RUN_ID is not null and (BMRUNEO.MARKED_FOR_RELEASE is null or BMRUNEO.MARKED_FOR_RELEASE != 1)) then BMRUNEO.release_status else DemandsEO.release_status END as release_status, CASE when (BMRUNEO.BM_RUN_ID is not null ) then BMRUNEO.release_status else DemandsEO.release_status END as release_status_orig, (select MSC_SPUI_COMMON.planner_code(BMRUNEO.INVENTORY_ITEM_ID,BMRUNEO.ORGANIZATION_ID,-1) from dual) AS PLANNER_CODE, 1 AS Object_Version_Number, DemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID, DemandsEO.SUPPLIER_SITE_SOURCE_SYSTEM_ID AS SCHED_SUP_SITE_SYSTEM_ID, (select msc_gopui_util.get_instance_code(supplier_site_source_system_id) from dual) AS SCHED_SUP_SITE_SYSTEM, CASE WHEN (DEMANDSEO.demand_source_type = 1 AND DEMANDSEO.expense_transfer = 1) THEN 'TOE' WHEN (DEMANDSEO.demand_source_type = 1 AND (DEMANDSEO.expense_transfer = 2 OR DEMANDSEO.expense_transfer IS NULL )) THEN 'TO' WHEN (DEMANDSEO.demand_source_type = 8 AND DEMANDSEO.expense_transfer = 1) THEN 'ISOE' WHEN (DEMANDSEO.demand_source_type = 8 AND (DEMANDSEO.expense_transfer = 2 OR DEMANDSEO.expense_transfer IS NULL )) THEN 'ISO' END AS INTERNAL_ORDER_TYPE, BMRUNEO.LAST_UPDATED_BY AS LAST_UPDATED_BY, BMRUNEO.LAST_UPDATE_DATE AS LAST_UPDATE_DATE, DemandsEO.SET_HEADER_NAME as SET_HEADER_NAME, 2 as ROW_TYPE, DECODE(BMRUNEO.BM_RUN_ID, -1,null,BMRUNEO.OVERRIDE_PRIORITY) AS OVERRIDE_PRIORITY, DECODE( demandsEO.ORDER_DATE_TYPE_CODE, 1, BMRUNEO.EXPECTED_SHIP_DATE, 2, BMRUNEO.EXPECTED_ARRIVAL_DATE, BMRUNEO.EXPECTED_SHIP_DATE) AS EXPECTED_DATE, BMRUNEO.REQUESTED_DATE, null as MODIFIED, DemandsEO.ORDERED_DATE AS creation_date, nvl(DemandsEO.INQUIRY_DEMAND,2) AS INQUIRY_DEMAND, DEMANDSEO.expense_transfer, ( CASE WHEN (DemandsEO.demand_source_type=1 OR DemandsEO.demand_source_type =8) THEN (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE',94) from dual) ELSE (select msc_get_name.lookup_meaning('MSC_ORDER_TYPE',1030) from dual) END) AS SOURCE_DOC_ORDER_TYPE_STR, case when (BMRUNEO.bm_run_id is not null and NVL(DemandsEO.SHIP_SET_NAME,DemandsEO.ARRIVAL_SET_NAME) is not null and nvl(BMRUNEO.SHIP_SET_NAME,BMRUNEO.ARRIVAL_SET_NAME) is null ) then 1 else 2 end AS removed_from_set, DemandsEO.order_line_status, BMRunEO.CONSTRAINT_RANK, BMRunEO.DAYS_POTENTIALLY_IMPROVE, BMRunEO.PLANNED_DATE_WITHOUT_ITEM, BMRunEO.SPLIT_INDICATOR, BMRunEO.BM_PARENT_FULFILLMENT_LINE AS ORIG_PARENT_FUL_LINE, DemandsEO.ATTRIBUTE_CATEGORY, DemandsEO.ATTRIBUTE_CHAR1, DemandsEO.ATTRIBUTE_CHAR2, DemandsEO.ATTRIBUTE_CHAR3, DemandsEO.ATTRIBUTE_CHAR4, DemandsEO.ATTRIBUTE_CHAR5, DemandsEO.ATTRIBUTE_CHAR6, DemandsEO.ATTRIBUTE_CHAR7, DemandsEO.ATTRIBUTE_CHAR8, DemandsEO.ATTRIBUTE_CHAR9, DemandsEO.ATTRIBUTE_CHAR10, DemandsEO.ATTRIBUTE_CHAR11, DemandsEO.ATTRIBUTE_CHAR12, DemandsEO.ATTRIBUTE_CHAR13, DemandsEO.ATTRIBUTE_CHAR14, DemandsEO.ATTRIBUTE_CHAR15, DemandsEO.ATTRIBUTE_CHAR16, DemandsEO.ATTRIBUTE_CHAR17, DemandsEO.ATTRIBUTE_CHAR18, DemandsEO.ATTRIBUTE_CHAR19, DemandsEO.ATTRIBUTE_CHAR20, DemandsEO.ATTRIBUTE_NUMBER1, DemandsEO.ATTRIBUTE_NUMBER2, DemandsEO.ATTRIBUTE_NUMBER3, DemandsEO.ATTRIBUTE_NUMBER4, DemandsEO.ATTRIBUTE_NUMBER5, DemandsEO.ATTRIBUTE_NUMBER6, DemandsEO.ATTRIBUTE_NUMBER7, DemandsEO.ATTRIBUTE_NUMBER8, DemandsEO.ATTRIBUTE_NUMBER9, DemandsEO.ATTRIBUTE_NUMBER10, DemandsEO.ATTRIBUTE_DATE1, DemandsEO.ATTRIBUTE_DATE2, DemandsEO.ATTRIBUTE_DATE3, DemandsEO.ATTRIBUTE_DATE4, DemandsEO.ATTRIBUTE_DATE5, DemandsEO.ATTRIBUTE_DATE6, DemandsEO.ATTRIBUTE_DATE7, DemandsEO.ATTRIBUTE_DATE8, DemandsEO.ATTRIBUTE_DATE9, DemandsEO.ATTRIBUTE_DATE10, DemandsEO.ATTRIBUTE_DATE11, DemandsEO.ATTRIBUTE_DATE12, DemandsEO.ATTRIBUTE_DATE13, DemandsEO.ATTRIBUTE_DATE14, DemandsEO.ATTRIBUTE_DATE15, DemandsEO.ATTRIBUTE_DATE16, DemandsEO.ATTRIBUTE_DATE17, DemandsEO.ATTRIBUTE_DATE18, DemandsEO.ATTRIBUTE_DATE19, DemandsEO.ATTRIBUTE_DATE20, DemandsEO.GLOBAL_ATTRIBUTE_CHAR1, DemandsEO.GLOBAL_ATTRIBUTE_CHAR2, DemandsEO.GLOBAL_ATTRIBUTE_CHAR3, DemandsEO.GLOBAL_ATTRIBUTE_CHAR4, DemandsEO.GLOBAL_ATTRIBUTE_CHAR5, DemandsEO.GLOBAL_ATTRIBUTE_CHAR6, DemandsEO.GLOBAL_ATTRIBUTE_CHAR7, DemandsEO.GLOBAL_ATTRIBUTE_CHAR8, DemandsEO.GLOBAL_ATTRIBUTE_CHAR9, DemandsEO.GLOBAL_ATTRIBUTE_CHAR10, DemandsEO.GLOBAL_ATTRIBUTE_CHAR11, DemandsEO.GLOBAL_ATTRIBUTE_CHAR12, DemandsEO.GLOBAL_ATTRIBUTE_CHAR13, DemandsEO.GLOBAL_ATTRIBUTE_CHAR14, DemandsEO.GLOBAL_ATTRIBUTE_CHAR15, DemandsEO.GLOBAL_ATTRIBUTE_CHAR16, DemandsEO.GLOBAL_ATTRIBUTE_CHAR17, DemandsEO.GLOBAL_ATTRIBUTE_CHAR18, DemandsEO.GLOBAL_ATTRIBUTE_CHAR19, DemandsEO.GLOBAL_ATTRIBUTE_CHAR20, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER1, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER2, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER3, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER4, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER5, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER6, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER7, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER8, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER9, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER10, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER11, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER12, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER13, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER14, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER15, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER16, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER17, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER18, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER19, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER20, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER21, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER22, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER23, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER24, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER25, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER26, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER27, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER28, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER29, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER30, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER31, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER32, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER33, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER34, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER35, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER36, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER37, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER38, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER39, DemandsEO.GLOBAL_ATTRIBUTE_NUMBER40, DemandsEO.GLOBAL_ATTRIBUTE_DATE1, DemandsEO.GLOBAL_ATTRIBUTE_DATE2, DemandsEO.GLOBAL_ATTRIBUTE_DATE3, DemandsEO.GLOBAL_ATTRIBUTE_DATE4, DemandsEO.GLOBAL_ATTRIBUTE_DATE5, DemandsEO.GLOBAL_ATTRIBUTE_DATE6, DemandsEO.GLOBAL_ATTRIBUTE_DATE7, DemandsEO.GLOBAL_ATTRIBUTE_DATE8, DemandsEO.GLOBAL_ATTRIBUTE_DATE9, DemandsEO.GLOBAL_ATTRIBUTE_DATE10, DemandsEO.GLOBAL_ATTRIBUTE_DATE11, DemandsEO.GLOBAL_ATTRIBUTE_DATE12, DemandsEO.GLOBAL_ATTRIBUTE_DATE13, DemandsEO.GLOBAL_ATTRIBUTE_DATE14, DemandsEO.GLOBAL_ATTRIBUTE_DATE15, DemandsEO.GLOBAL_ATTRIBUTE_DATE16, DemandsEO.GLOBAL_ATTRIBUTE_DATE17, DemandsEO.GLOBAL_ATTRIBUTE_DATE18, DemandsEO.GLOBAL_ATTRIBUTE_DATE19, DemandsEO.GLOBAL_ATTRIBUTE_DATE20 from msc_demands DemandsEO, msc_bm_run_demands BMRUNEO, (SELECT CategoryEO.CATEGORY_ID, CategoryEO.CATEGORY_SET_ID, CategoryEO.CATEGORY_NAME, ItemCategoriesEO.inventory_item_id, ItemCategoriesEO.organization_id, SetEO.CATEGORY_SET_NAME as CATALOG_NAME FROM MSC_CATALOG_CATEGORIES CategoryEO, MSC_ITEM_CATEGORIES ItemCategoriesEO, MSC_CATEGORY_SETS SetEO WHERE CategoryEO.category_set_id = NVL(fnd_profile.value('MSC_SRC_ASSIGNMENT_CATALOG'),2) AND CategoryEO.category_id = ItemCategoriesEO.category_id AND CategoryEO.category_set_id = SetEO.category_set_id )ItemCategoryEO WHERE DemandsEO.plan_id = -1 AND DemandsEO.origination_type = 1030 AND DemandsEO.plan_id = BMRunEO.bm_run_id(+) AND DemandsEO.demand_id = BMRUNEO.base_demand_id and BMRUNEO.DEMAND_ID != BMRUNEO.BASE_DEMAND_ID and BMRUNEO.DEMAND_ID not in (select demand_id from msc_demands where plan_id = -1 and origination_type=1030) AND ItemCategoryEO.organization_id(+) = BMRunEO.organization_id AND ItemCategoryEO.inventory_item_id(+) = BMRunEO.inventory_item_id AND DemandsEO.REQUEST_DATE IS NOT NULL AND ((DEMANDSEO.expense_transfer IS NULL OR DEMANDSEO.expense_transfer =2) OR (DEMANDSEO.expense_transfer =1 AND DEMANDSEO.interfaced_to_doo =1))