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.

[Home] [Help]

View: MSC_ORDERS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view shjows all the supplies,demands anf sales orders
Implementation/DBA Data:	APPS.MSC_ORDERS_V

View Text

SELECT 'MSC_SUPPLIES'
, SUP.ROWID
, SUP.TRANSACTION_ID
, SUP.LAST_UPDATE_DATE
, SUP.LAST_UPDATED_BY
, SUP.CREATION_DATE
, SUP.CREATED_BY
, SUP.LAST_UPDATE_LOGIN
, MSI.INVENTORY_ITEM_ID
, SUP.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUP.SR_INSTANCE_ID
, SUP.PLAN_ID
, NULL
, MSC_GET_NAME.ACTION('MSC_SUPPLIES'
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSI.WIP_SUPPLY_TYPE
, SUP.ORDER_TYPE
, DECODE(SUP.FIRM_PLANNED_TYPE
, 1
, 1
, SUP.RESCHEDULE_FLAG)
, SUP.DISPOSITION_STATUS_TYPE
, SUP.NEW_SCHEDULE_DATE
, SUP.OLD_SCHEDULE_DATE
, SUP.IMPLEMENTED_QUANTITY
, SUP.QUANTITY_IN_PROCESS
, DECODE(SUP.NEW_ORDER_QUANTITY
, 0
, SUP.FIRM_QUANTITY
, SUP.NEW_ORDER_QUANTITY)
, NULL
, SUP.RESCHEDULE_DAYS
, SUP.FIRM_QUANTITY)
, SUP.NEW_SCHEDULE_DATE
, SUP.OLD_SCHEDULE_DATE
, SUP.NEW_WIP_START_DATE
, SUP.DISPOSITION_ID
, DECODE(SUP.ORDER_TYPE
, 5
, TO_CHAR(SUP.TRANSACTION_ID)
, SUP.ORDER_NUMBER)
, SUP.DISPOSITION_STATUS_TYPE
, SUP.ORDER_TYPE
, L1.MEANING
, NVL(SUP.DAILY_RATE
, SUP.NEW_ORDER_QUANTITY)
, SUP.OLD_ORDER_QUANTITY
, SUP.NEW_ORDER_PLACEMENT_DATE
, SUP.FIRM_PLANNED_TYPE
, SUP.RESCHEDULE_FLAG
, SUP.NEW_PROCESSING_DAYS
, SUP.IMPLEMENTED_QUANTITY
, SUP.LAST_UNIT_COMPLETION_DATE
, SUP.FIRST_UNIT_START_DATE
, SUP.LAST_UNIT_START_DATE
, SUP.NEW_DOCK_DATE
, SUP.QUANTITY_IN_PROCESS
, SUP.FIRM_QUANTITY
, SUP.FIRM_DATE
, SUP.LINE_ID
, DECODE(SUP.LINE_ID
, NULL
, NULL
, MSC_GET_NAME.DEPARTMENT_CODE(1
, SUP.LINE_ID
, SUP.ORGANIZATION_ID
, SUP.PLAN_ID
, SUP.SR_INSTANCE_ID))
, SUP.IMPLEMENT_DEMAND_CLASS
, MSI.ITEM_NAME
, SUP.IMPLEMENT_DATE
, NVL(SUP.IMPLEMENT_DAILY_RATE
, SUP.IMPLEMENT_QUANTITY)
, SUP.IMPLEMENT_FIRM
, TO_NUMBER(NULL)
, SUP.IMPLEMENT_WIP_CLASS_CODE
, SUP.IMPLEMENT_JOB_NAME
, TO_NUMBER(NULL)
, SUP.IMPLEMENT_STATUS_CODE
, SUP.IMPLEMENT_LOCATION_ID
, NVL(SUP.RELEASE_STATUS
, 2)
, SUP.IMPLEMENT_AS
, DECODE(SUP.IMPLEMENT_AS
, NULL
, NULL
, MSC_GET_NAME.LOOKUP_MEANING('MRP_WORKBENCH_IMPLEMENT_AS'
, SUP.IMPLEMENT_AS))
, MSI.PLANNER_CODE
, TO_NUMBER(NULL)
, MIC.SR_CATEGORY_ID
, MSI.MRP_PLANNING_CODE
, MSI.REPETITIVE_TYPE
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.PLANNING_MAKE_BUY_CODE
, GREATEST(0
, SUP.NEW_ORDER_PLACEMENT_DATE - (TRUNC(SYSDATE) ))
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSI.WIP_SUPPLY_TYPE
, SUP.SOURCE_ORGANIZATION_ID
, SUP.SOURCE_SR_INSTANCE_ID
, DECODE(SUP.SOURCE_SUPPLIER_ID
, NULL
, MSC_GET_NAME.ORG_CODE(SUP.SOURCE_ORGANIZATION_ID
, SUP.SOURCE_SR_INSTANCE_ID)
, NULL)
, SUP.WIP_STATUS_CODE
, NULL
, MSI.FULL_PEGGING
, SUP.SOURCE_SUPPLIER_ID
, MSC_GET_NAME.SUPPLIER(DECODE(SUP.PLAN_ID
, -1
, SUP.SUPPLIER_ID
, DECODE(SUP.ORDER_TYPE
, 1
, SUP.SUPPLIER_ID
, 2
, SUP.SUPPLIER_ID
, 8
, SUP.SUPPLIER_ID
, SUP.SOURCE_SUPPLIER_ID)))
, SUP.SOURCE_SUPPLIER_SITE_ID
, MSC_GET_NAME.SUPPLIER_SITE(DECODE(SUP.PLAN_ID
, -1
, SUP.SUPPLIER_SITE_ID
, DECODE(SUP.ORDER_TYPE
, 1
, SUP.SUPPLIER_SITE_ID
, 2
, SUP.SUPPLIER_SITE_ID
, 8
, SUP.SUPPLIER_SITE_ID
, SUP.SOURCE_SUPPLIER_SITE_ID)))
, SUP.SUPPLIER_ID
, NULL
, SUP.SUPPLIER_SITE_ID
, NULL
, SUP.IMPLEMENT_SOURCE_ORG_ID
, SUP.IMPLEMENT_SR_INSTANCE_ID
, SUP.IMPLEMENT_SUPPLIER_ID
, SUP.IMPLEMENT_SUPPLIER_SITE_ID
, DECODE(MSI.IN_SOURCE_PLAN
, 1
, 1
, 2)
, SUP.SCHEDULE_COMPRESS_DAYS
, SUP.PROJECT_ID
, SUP.TASK_ID
, DECODE(SUP.PROJECT_ID
, NULL
, NULL
, MSC_GET_NAME.PROJECT(SUP.PROJECT_ID
, SUP.ORGANIZATION_ID
, SUP.PLAN_ID
, SUP.SR_INSTANCE_ID))
, DECODE(SUP.TASK_ID
, NULL
, NULL
, MSC_GET_NAME.TASK(SUP.TASK_ID
, SUP.PROJECT_ID
, SUP.ORGANIZATION_ID
, SUP.PLAN_ID
, SUP.SR_INSTANCE_ID))
, SUP.IMPLEMENT_PROJECT_ID
, SUP.IMPLEMENT_TASK_ID
, SUP.PLANNING_GROUP
, SUP.STATUS
, 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))
, 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))
, DECODE(SUP.PLAN_ID
, -1
, SUP.ALTERNATE_BOM_DESIGNATOR
, MSC_GET_NAME.ALTERNATE_BOM(PE.PLAN_ID
, PE.SR_INSTANCE_ID
, PE.BILL_SEQUENCE_ID))
, DECODE(SUP.PLAN_ID
, -1
, SUP.ALTERNATE_ROUTING_DESIGNATOR
, MSC_GET_NAME.ALTERNATE_RTG(PE.PLAN_ID
, PE.SR_INSTANCE_ID
, PE.ROUTING_SEQUENCE_ID))
, SUP.PROCESS_SEQ_ID
, SUP.IMPLEMENT_ALTERNATE_BOM
, SUP.IMPLEMENT_ALTERNATE_ROUTING
, SUP.SCHEDULE_GROUP_NAME
, SUP.IMPLEMENT_EMPLOYEE_ID
, MSC_GET_NAME.CFM_ROUTING_FLAG(PE.PLAN_ID
, PE.SR_INSTANCE_ID
, PE.ROUTING_SEQUENCE_ID)
, MSI.BUYER_NAME
, SUP.RELEASE_ERRORS
, SUP.NUMBER1
, SUP.UNIT_NUMBER
, SUP.IMPLEMENT_UNIT_NUMBER
, MSI.DESCRIPTION
, NVL(SUP.PLANNING_GROUP
, '0')
, NVL(MSI.BUYER_NAME
, '0')
, NVL(MSI.PLANNER_CODE
, '0')
, NVL(SUP.PROJECT_ID
, 0)
, NVL(SUP.TASK_ID
, 0)
, NULL
, NULL
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MSI.PRODUCT_FAMILY_ID
, MSC_GET_NAME.ITEM_NAME(MSI.PRODUCT_FAMILY_ID
, NULL
, NULL
, NULL)
, MSC_GET_NAME.ITEM_NAME(MSI.BASE_ITEM_ID
, NULL
, NULL
, NULL)
, MSI.ABC_CLASS_NAME
, MSI.UOM_CODE
, NULL
, TO_NUMBER(NULL)
, SUP.PROMISED_DATE
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, SUP.LOT_NUMBER
, SUP.SUBINVENTORY_CODE
, TO_NUMBER(NULL)
, DECODE(SUP.ORDER_TYPE
, 3
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 7
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 27
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 30
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, TO_NUMBER(NULL))
, MSC_GET_NAME.LOOKUP_MEANING('WIP_JOB_STATUS'
, DECODE(SUP.ORDER_TYPE
, 3
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 7
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 27
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, 30
, MSC_GET_NAME.WIP_STATUS(SUP.TRANSACTION_ID)
, TO_NUMBER(NULL)))
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, SUP.NEED_BY_DATE
, DECODE(SUP.SCHEDULE_DESIGNATOR_ID
, NULL
, NULL
, MSC_GET_NAME.DESIGNATOR(SUP.SCHEDULE_DESIGNATOR_ID))
, MSI.LIST_PRICE
, MSI.STANDARD_COST
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUP.DEMAND_CLASS
, TO_NUMBER(NULL)
, SUP.NEW_SHIP_DATE
, NVL(SUP.DAILY_RATE
, SUP.NEW_ORDER_QUANTITY)
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, SUP.PURCH_LINE_NUM
, SUP.RESCHEDULE_DAYS
, DECODE(SUP.PLAN_ID
, -1
, SUP.NEW_DOCK_DATE
, SUP.OLD_NEED_BY_DATE)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, SUP.SHIP_METHOD
, SUP.EXPLOSION_DATE
, TO_NUMBER(NULL)
, SUP.ORIGINAL_QUANTITY
, SUP.ORIGINAL_NEED_BY_DATE
, SUP.EARLIEST_START_DATE
, SUP.EARLIEST_COMPLETION_DATE
, SUP.MIN_START_DATE
, MSI.LOW_LEVEL_CODE
, ROUND(NVL(SUP.EARLIEST_COMPLETION_DATE-SUP.NEED_BY_DATE
, 0)
, 2)
, SUP.ULPSD
, SUP.ULPCD
, SUP.UEPSD
, SUP.UEPCD
, SUP.EACD
, SUP.SUPPLY_IS_SHARED
, SUP.RECORD_SOURCE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SUP.WIP_START_QUANTITY
, SUP.EXPIRATION_DATE
FROM MSC_SUPPLIES SUP
, MFG_LOOKUPS L1
, MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
, MSC_PROCESS_EFFECTIVITY PE
WHERE PE.PLAN_ID(+) = SUP.PLAN_ID
AND PE.SR_INSTANCE_ID(+) = SUP.SR_INSTANCE_ID
AND PE.PROCESS_SEQUENCE_ID(+) = SUP.PROCESS_SEQ_ID
AND MIC.SR_INSTANCE_ID = SUP.SR_INSTANCE_ID
AND MIC.ORGANIZATION_ID = SUP.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = SUP.INVENTORY_ITEM_ID
AND SUP.PLAN_ID = MSI.PLAN_ID
AND SUP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND SUP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SUP.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND L1.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND L1.LOOKUP_CODE = SUP.ORDER_TYPE UNION ALL SELECT 'MSC_DEMANDS'
, DEM.ROWID
, DEM.DEMAND_ID
, DEM.LAST_UPDATE_DATE
, DEM.LAST_UPDATED_BY
, DEM.CREATION_DATE
, DEM.CREATED_BY
, DEM.LAST_UPDATE_LOGIN
, MSI.INVENTORY_ITEM_ID
, DEM.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DEM.SR_INSTANCE_ID
, DEM.PLAN_ID
, NULL
, MSC_GET_NAME.ACTION('MSC_DEMANDS'
, DEM.PLAN_ID
, DECODE(DEM.PLAN_ID
, -1
, DEM.SUPPLY_ID
, DEM.DISPOSITION_ID)
, DEM.SR_INSTANCE_ID
, DEM.ORIGINATION_TYPE)
, DEM.USING_ASSEMBLY_DEMAND_DATE
, DEM.OLD_DEMAND_DATE
, TO_DATE(NULL)
, DEM.DISPOSITION_ID
, NVL(DEM.ORDER_NUMBER
, DECODE(DEM.ORIGINATION_TYPE
, 1
, TO_CHAR(DEM.DISPOSITION_ID)
, 29
, DECODE(DEM.PLAN_ID
, -1
, MSC_GET_NAME.DESIGNATOR(DEM.SCHEDULE_DESIGNATOR_ID)
, MSC_GET_NAME.SCENARIO_DESIGNATOR(DEM.FORECAST_SET_ID
, DEM.PLAN_ID
, DEM.ORGANIZATION_ID
, DEM.SR_INSTANCE_ID))
, MSC_GET_NAME.DESIGNATOR(DEM.SCHEDULE_DESIGNATOR_ID)))
, TO_NUMBER(NULL)
, DEM.ORIGINATION_TYPE
, L1.MEANING
, - NVL(DEM.DAILY_DEMAND_RATE
, DEM.USING_REQUIREMENT_QUANTITY)
, DEM.OLD_DEMAND_QUANTITY
, TO_DATE(NULL)
, TO_NUMBER(NVL(NULL
, 2))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DEM.ASSEMBLY_DEMAND_COMP_DATE
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, DEM.FIRM_QUANTITY
, DEM.FIRM_DATE
, TO_NUMBER(NULL)
, NULL
, NULL
, MSI.ITEM_NAME
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSI.PLANNER_CODE
, DEM.USING_ASSEMBLY_ITEM_ID
, MIC.SR_CATEGORY_ID
, MSI.MRP_PLANNING_CODE
, MSI.REPETITIVE_TYPE
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.PLANNING_MAKE_BUY_CODE
, GREATEST(0
, USING_ASSEMBLY_DEMAND_DATE - (TRUNC(SYSDATE) ))
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSI.WIP_SUPPLY_TYPE
, DEM.SOURCE_ORGANIZATION_ID
, DEM.SOURCE_ORG_INSTANCE_ID
, DECODE(DEM.SUPPLY_ID
, NULL
, DECODE(DEM.ORIGINATION_TYPE
, 6
, DECODE(MSC_GET_NAME.ORDER_TYPE(DEM.PLAN_ID
, DEM.DISPOSITION_ID
, DEM.SR_INSTANCE_ID)
, 2
, NULL
, MSC_GET_NAME.ORG_CODE(DEM.SOURCE_ORGANIZATION_ID
, DEM.SOURCE_ORG_INSTANCE_ID))
, 30
, DECODE(MSC_GET_NAME.ORDER_TYPE(DEM.PLAN_ID
, DEM.DISPOSITION_ID
, DEM.SR_INSTANCE_ID)
, 2
, NULL
, MSC_GET_NAME.ORG_CODE(DEM.SOURCE_ORGANIZATION_ID
, DEM.SOURCE_ORG_INSTANCE_ID))
, MSC_GET_NAME.ORG_CODE(DEM.SOURCE_ORGANIZATION_ID
, DEM.SOURCE_ORG_INSTANCE_ID))
, NULL )
, TO_NUMBER(NULL)
, MSC_GET_NAME.ITEM_NAME(DEM.USING_ASSEMBLY_ITEM_ID
, NULL
, NULL
, NULL)
, MSI.FULL_PEGGING
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MSI.IN_SOURCE_PLAN
, 1
, 1
, 2)
, TO_NUMBER(NULL)
, DEM.PROJECT_ID
, DEM.TASK_ID
, DECODE(DEM.PROJECT_ID
, NULL
, NULL
, MSC_GET_NAME.PROJECT(DEM.PROJECT_ID
, DEM.ORGANIZATION_ID
, DEM.PLAN_ID
, DEM.SR_INSTANCE_ID))
, DECODE(DEM.TASK_ID
, NULL
, NULL
, MSC_GET_NAME.TASK(DEM.TASK_ID
, DEM.PROJECT_ID
, DEM.ORGANIZATION_ID
, DEM.PLAN_ID
, DEM.SR_INSTANCE_ID))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DEM.PLANNING_GROUP
, DEM.STATUS
, DEM.APPLIED
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSI.BUYER_NAME
, NULL
, TO_NUMBER(NULL)
, DEM.UNIT_NUMBER
, NULL
, MSI.DESCRIPTION
, NVL(DEM.PLANNING_GROUP
, '0')
, NVL(MSI.BUYER_NAME
, '0')
, NVL(MSI.PLANNER_CODE
, '0')
, NVL(DEM.PROJECT_ID
, 0)
, NVL(DEM.TASK_ID
, 0)
, DECODE(DEM.LENDING_PROJECT_ID
, NULL
, NULL
, MSC_GET_NAME.PROJECT(DEM.LENDING_PROJECT_ID
, DEM.ORGANIZATION_ID
, DEM.PLAN_ID
, DEM.SR_INSTANCE_ID))
, DECODE(DEM.LENDING_TASK_ID
, NULL
, NULL
, MSC_GET_NAME.TASK(DEM.LENDING_TASK_ID
, DEM.LENDING_PROJECT_ID
, DEM.ORGANIZATION_ID
, DEM.PLAN_ID
, DEM.SR_INSTANCE_ID))
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MSI.PRODUCT_FAMILY_ID
, MSC_GET_NAME.ITEM_NAME(MSI.PRODUCT_FAMILY_ID
, NULL
, NULL
, NULL)
, MSC_GET_NAME.ITEM_NAME(MSI.BASE_ITEM_ID
, NULL
, NULL
, NULL)
, MSI.ABC_CLASS_NAME
, MSI.UOM_CODE
, DECODE(DEM.ORIGINATION_TYPE
, 24
, DEM.ORDER_NUMBER
, NULL)
, DECODE(DEM.PLAN_ID
, -1
, DEM.ORDER_PRIORITY
, DEM.DEMAND_PRIORITY)
, DEM.PROMISE_DATE
, DEM.REQUEST_DATE
, DEM.CUSTOMER_ID
, MSC_GET_NAME.CUSTOMER(DEM.CUSTOMER_ID)
, DEM.CUSTOMER_SITE_ID
, MSC_GET_NAME.CUSTOMER_SITE(DEM.CUSTOMER_SITE_ID)
, DEM.SHIP_TO_SITE_ID
, MSC_GET_NAME.CUSTOMER_SITE(DEM.SHIP_TO_SITE_ID)
, NULL
, NULL
, DEM.PARENT_ID
, TO_NUMBER(NULL)
, NULL
, DEM.DMD_LATENESS_COST
, DEM.DMD_SATISFIED_DATE
, TO_DATE(NULL)
, DECODE(DEM.SCHEDULE_DESIGNATOR_ID
, NULL
, NULL
, DECODE(DEM.ORIGINATION_TYPE
, 29
, MSC_GET_NAME.FORECASTSETNAME(DEM.FORECAST_SET_ID
, DEM.PLAN_ID
, DEM.ORGANIZATION_ID
, DEM.SR_INSTANCE_ID)
, MSC_GET_NAME.DESIGNATOR(DEM.SCHEDULE_DESIGNATOR_ID)))
, MSI.LIST_PRICE
, MSI.STANDARD_COST
, DEM.SELLING_PRICE
, DEM.SERVICE_LEVEL
, DEM.DEMAND_CLASS
, DEM.PROBABILITY
, TO_DATE(NULL)
, -(NVL(DEM.DAILY_DEMAND_RATE
, DEM.USING_REQUIREMENT_QUANTITY)) * NVL(DEM.PROBABILITY
, 1)
, DEM.ASSEMBLY_DEMAND_COMP_DATE
, DECODE(DEM.ORIGINATION_TYPE
, 1
, NULL
, 4
, NULL
, 16
, NULL
, 17
, NULL
, 18
, NULL
, 19
, NULL
, 20
, NULL
, 21
, NULL
, 23
, NULL
, 25
, NULL
, 26
, NULL
, 28
, NULL
, 22
, NULL
, DECODE(DEM.BUCKET_TYPE
, 1
, 'DAYS'
, 2
, 'WEEKS'
, 3
, 'PERIODS'
, NULL) )
, DECODE(DEM.ORIGINATION_TYPE
, 6
, MSC_GET_NAME.SOURCE_DEMAND_PRIORITY( DEM.PLAN_ID
, DEM.DEMAND_ID)
, 7
, MSC_GET_NAME.SOURCE_DEMAND_PRIORITY( DEM.PLAN_ID
, DEM.DEMAND_ID)
, 8
, MSC_GET_NAME.SOURCE_DEMAND_PRIORITY( DEM.PLAN_ID
, DEM.DEMAND_ID)
, 29
, MSC_GET_NAME.SOURCE_DEMAND_PRIORITY( DEM.PLAN_ID
, DEM.DEMAND_ID)
, 30
, MSC_GET_NAME.SOURCE_DEMAND_PRIORITY( DEM.PLAN_ID
, DEM.DEMAND_ID)
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, DEM.CUMMULATIVE_PROBABILITY
, DEM.ORIGINAL_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(DEM.ORIGINAL_ITEM_ID
, NULL
, NULL
, NULL)
, MSC_GET_NAME.DEMAND_QUANTITY(DEM.PLAN_ID
, DEM.SR_INSTANCE_ID
, DEM.DEMAND_ID)
, NULL
, TO_DATE(NULL)
, DEM.UNMET_QUANTITY
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, MSI.LOW_LEVEL_CODE
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, DEM.RECORD_SOURCE
, DECODE(DEM.ORIGINATION_TYPE
, 29
, MSC_GET_NAME.FORWARD_BACKWARD_DAYS(DEM.PLAN_ID
, DEM.SCHEDULE_DESIGNATOR_ID
, 1)
, NULL)
, DECODE(DEM.ORIGINATION_TYPE
, 29
, MSC_GET_NAME.FORWARD_BACKWARD_DAYS(DEM.PLAN_ID
, DEM.SCHEDULE_DESIGNATOR_ID
, 2)
, NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
FROM MSC_DEMANDS DEM
, MFG_LOOKUPS L1
, MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
WHERE ( 'MSC_DEMAND_ORIGINATION') = L1.LOOKUP_TYPE
AND L1.LOOKUP_CODE = DEM.ORIGINATION_TYPE
AND MIC.SR_INSTANCE_ID = DEM.SR_INSTANCE_ID
AND MIC.ORGANIZATION_ID = DEM.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = DEM.INVENTORY_ITEM_ID
AND DEM.PLAN_ID = MSI.PLAN_ID
AND DEM.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND DEM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID UNION ALL SELECT /*+ INDEX(MSO MSC_SALES_ORDERS_N1) */ 'MSC_DEMANDS'
, MSO.ROWID
, MSO.DEMAND_ID
, MSO.LAST_UPDATE_DATE
, MSO.LAST_UPDATED_BY
, MSO.CREATION_DATE
, MSO.CREATED_BY
, MSO.LAST_UPDATE_LOGIN
, MSI.INVENTORY_ITEM_ID
, MSO.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSO.SR_INSTANCE_ID
, -1
, NULL
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ACTIONS'
, 6)
, MSO.REQUIREMENT_DATE
, TO_DATE(NULL)
, TO_DATE(NULL)
, MSO.DEMAND_ID
, MSO.SALES_ORDER_NUMBER
, TO_NUMBER(NULL)
, 30
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION'
, 30)
, -(MSO.PRIMARY_UOM_QUANTITY)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NVL(NULL
, 2))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, MSO.RESERVATION_QUANTITY
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, MSI.ITEM_NAME
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSI.PLANNER_CODE
, MSO.INVENTORY_ITEM_ID
, MIC.SR_CATEGORY_ID
, MSI.MRP_PLANNING_CODE
, MSI.REPETITIVE_TYPE
, MSI.BUILD_IN_WIP_FLAG
, MSI.PURCHASING_ENABLED_FLAG
, MSI.PLANNING_MAKE_BUY_CODE
, GREATEST(0
, MSO.REQUIREMENT_DATE - (TRUNC(SYSDATE) ))
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSI.WIP_SUPPLY_TYPE
, MSO.ORGANIZATION_ID
, MSO.SR_INSTANCE_ID
, MSC_GET_NAME.ORG_CODE(MSO.ORGANIZATION_ID
, MSO.SR_INSTANCE_ID)
, TO_NUMBER(NULL)
, MSC_GET_NAME.ITEM_NAME(MSO.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL)
, MSI.FULL_PEGGING
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MSI.IN_SOURCE_PLAN
, 1
, 1
, 2)
, TO_NUMBER(NULL)
, MSO.PROJECT_ID
, MSO.TASK_ID
, DECODE(MSO.PROJECT_ID
, NULL
, NULL
, MSC_GET_NAME.PROJECT(MSO.PROJECT_ID
, MSO.ORGANIZATION_ID
, -1
, MSO.SR_INSTANCE_ID))
, DECODE(MSO.TASK_ID
, NULL
, NULL
, MSC_GET_NAME.TASK(MSO.TASK_ID
, MSO.PROJECT_ID
, MSO.ORGANIZATION_ID
, -1
, MSO.SR_INSTANCE_ID))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSO.PLANNING_GROUP
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MSI.BUYER_NAME
, NULL
, TO_NUMBER(NULL)
, MSO.END_ITEM_UNIT_NUMBER
, NULL
, MSI.DESCRIPTION
, NVL(MSO.PLANNING_GROUP
, '0')
, NVL(MSI.BUYER_NAME
, '0')
, NVL(MSI.PLANNER_CODE
, '0')
, NVL(MSO.PROJECT_ID
, 0)
, NVL(MSO.TASK_ID
, 0)
, DECODE(MSO.PROJECT_ID
, NULL
, NULL
, MSC_GET_NAME.PROJECT(MSO.PROJECT_ID
, MSO.ORGANIZATION_ID
, -1
, MSO.SR_INSTANCE_ID))
, DECODE(MSO.TASK_ID
, NULL
, NULL
, MSC_GET_NAME.TASK(MSO.TASK_ID
, MSO.PROJECT_ID
, MSO.ORGANIZATION_ID
, -1
, MSO.SR_INSTANCE_ID))
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_NAME
, MSI.PRODUCT_FAMILY_ID
, MSC_GET_NAME.ITEM_NAME(MSI.PRODUCT_FAMILY_ID
, NULL
, NULL
, NULL)
, MSC_GET_NAME.ITEM_NAME(MSI.BASE_ITEM_ID
, NULL
, NULL
, NULL)
, MSI.ABC_CLASS_NAME
, MSI.UOM_CODE
, NULL
, TO_NUMBER(NULL)
, MSO.REQUIREMENT_DATE
, MSO.REQUEST_DATE
, MSO.CUSTOMER_ID
, MSC_GET_NAME.CUSTOMER(MSO.CUSTOMER_ID)
, MSO.SHIP_TO_SITE_USE_ID
, MSC_GET_NAME.CUSTOMER_SITE(MSO.SHIP_TO_SITE_USE_ID)
, MSO.SHIP_TO_SITE_USE_ID
, MSC_GET_NAME.CUSTOMER_SITE(MSO.SHIP_TO_SITE_USE_ID)
, NULL
, NULL
, MSO.PARENT_DEMAND_ID
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, MSO.REQUIREMENT_DATE
, TO_DATE(NULL)
, NULL
, MSI.LIST_PRICE
, MSI.STANDARD_COST
, MSO.SELLING_PRICE
, TO_NUMBER(NULL)
, MSO.DEMAND_CLASS
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, MSO.ORIGINAL_ITEM_ID
, MSC_GET_NAME.ITEM_NAME(MSO.ORIGINAL_ITEM_ID
, NULL
, NULL
, NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, MSI.LOW_LEVEL_CODE
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, MSO.RECORD_SOURCE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
FROM MSC_SALES_ORDERS MSO
, MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
WHERE MSO.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MSO.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSO.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSO.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSO.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSO.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSO.RESERVATION_TYPE = 1
AND MSI.PLAN_ID = -1

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
SR_INSTANCE_ID
PLAN_ID
COMPILE_DESIGNATOR
ACTION
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
NEW_PROCESSING_DAYS
IMPLEMENTED_QUANTITY
LAST_UNIT_COMPLETION_DATE
FIRST_UNIT_START_DATE
LAST_UNIT_START_DATE
NEW_DOCK_DATE
QUANTITY_IN_PROCESS
FIRM_QUANTITY
FIRM_DATE
LINE_ID
LINE_CODE
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
CATEGORY_ID
MRP_PLANNING_CODE
REPETITIVE_TYPE
BUILD_IN_WIP_FLAG
PURCHASING_ENABLED_FLAG
PLANNING_MAKE_BUY_CODE
DAYS_FROM_TODAY
BOM_ITEM_TYPE
BASE_ITEM_ID
WIP_SUPPLY_TYPE
SOURCE_ORGANIZATION_ID
SOURCE_SR_INSTANCE_ID
SOURCE_ORGANIZATION_CODE
STATUS_CODE
USING_ASSEMBLY_SEGMENTS
FULL_PEGGING
SOURCE_VENDOR_ID
SOURCE_VENDOR_NAME
SOURCE_VENDOR_SITE_ID
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
PROJECT_NUMBER
TASK_NUMBER
IMPLEMENT_PROJECT_ID
IMPLEMENT_TASK_ID
PLANNING_GROUP
STATUS
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
REL_ALL_QTY
UNIT_NUMBER
IMPLEMENT_UNIT_NUMBER
DESCRIPTION
PLANNING_GROUP_HIDDEN
BUYER_NAME_HIDDEN
PLANNER_CODE_HIDDEN
PROJECT_ID_HIDDEN
TASK_ID_HIDDEN
LENDING_PROJECT_NUMBER
LENDING_TASK_NUMBER
CATEGORY_SET_ID
CATEGORY_NAME
PRODUCT_FAMILY_ID
PRODUCT_FAMILY_NAME
BASE_ITEM_NAME
ABC_CLASS
UOM_CODE
INTERNAL_SO_NUMBER
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
PARENT_ID
WIP_STATUS_CODE
WIP_STATUS_TEXT
DMD_LATENESS_COST
DMD_SATISFIED_DATE
NEED_BY_DATE
DESIGNATOR_NAME
LIST_PRICE
STANDARD_COST
SELLING_PRICE
SERVICE_LEVEL
DEMAND_CLASS
PROBABILITY
SHIP_DATE
QUANTITY
ASSEMBLY_DEMAND_COMP_DATE
BUCKET_TYPE
SOURCE_DMD_PRIORITY
PO_LINE_ID
RESCHEDULE_DAYS
OLD_NEED_BY_DATE
CUMULATIVE_PROBABILITY
ORIGINAL_ITEM_ID
ORIGINAL_ITEM_NAME
ORIGINAL_ITEM_QTY
SHIP_METHOD
EXPLOSION_DATE
UNMET_QUANTITY
ORIGINAL_QUANTITY
ORIGINAL_NEED_BY_DATE
EPST
EPCT
MIN_START_TIME
LOW_LEVEL_CODE
ORDERS_DAYS_LATE
ULPSD
ULPCD
UEPSD
UEPCD
EACD
SUPPLY_IS_SHARED
RECORD_SOURCE
FORWARD_DAYS
BACKWARD_DAYS
WIP_START_QUANTITY
EXPIRATION_DATE