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_RELATED_EXC_DETAILS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_RELATED_EXC_DETAILS_V

View Text

SELECT /*+ FIRST_ROWS */ MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.INVENTORY_ITEM_ID
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MTP.ORGANIZATION_CODE
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MIF.ITEM_NAME
, MIF.DESCRIPTION
, MIF.BUYER_NAME
, MIF.PLANNER_CODE
, ML.MEANING
, NVL(MGR.PROJECT_ID
, 0)
, NVL(MGR.TASK_ID
, 0)
, NVL(MGR.PLANNING_GROUP
, '0')
, MSC_GET_NAME.PROJECT(MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.TASK_ID
, MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MGR.PLANNING_GROUP
, NULL
, NULL
, MGR.USING_ASSEMBLY_DEMAND_DATE
, MED.DATE1
, MED.DATE2
, TO_NUMBER(NULL)
, MGR.USING_REQUIREMENT_QUANTITY
, NULL
, NVL(MGR.ORDER_NUMBER
, MSC_GET_NAME.DESIGNATOR(MGR.SCHEDULE_DESIGNATOR_ID))
, NULL
, MSC_GET_NAME.ITEM_NAME(MGR.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL)
, NULL
, NVL(MGR.ORDER_NUMBER
, MSC_GET_NAME.DESIGNATOR(MGR.SCHEDULE_DESIGNATOR_ID))
, DECODE (MED.EXCEPTION_TYPE
, 67
, MED.NUMBER1
, TO_NUMBER(NULL))
, MGR.DEMAND_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, DECODE (MED.EXCEPTION_TYPE
, 67
, MED.QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, MGR.CUSTOMER_ID
, MSC_GET_NAME.CUSTOMER(MGR.CUSTOMER_ID)
, MGR.CUSTOMER_SITE_ID
, MSC_GET_NAME.CUSTOMER_SITE(MGR.CUSTOMER_SITE_ID)
, MGR.DEMAND_PRIORITY
, MGR.DMD_SATISFIED_DATE
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, MGR.USING_REQUIREMENT_QUANTITY
, MGR.OLD_DEMAND_DATE
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MGR.QUANTITY_BY_DUE_DATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ROUND(GREATEST( MGR.DMD_SATISFIED_DATE - MGR.USING_ASSEMBLY_DEMAND_DATE
, 0.01)
, 2)
, NVL(MED.NUMBER4
, 1)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ORIGINATION_CODE_TYPE'
, NVL(MED.NUMBER4
, 1))
, MGR.DEMAND_CLASS
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, DECODE(MED.EXCEPTION_TYPE
, 67
, MED.QUANTITY
, TO_NUMBER(NULL))
, NULL
FROM MSC_EXCEPTION_DETAILS MED
, MSC_SYSTEM_ITEMS MIF
, MSC_ITEM_CATEGORIES MIC
, MSC_DEMANDS MGR
, MSC_TRADING_PARTNERS MTP
, MFG_LOOKUPS ML
WHERE MIC.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MIC.SR_INSTANCE_ID = MIF.SR_INSTANCE_ID
AND MIC.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND MIF.INVENTORY_ITEM_ID = MED.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MED.ORGANIZATION_ID
AND MIF.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MIF.PLAN_ID = MED.PLAN_ID
AND MGR.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MGR.DEMAND_ID = MED.NUMBER1
AND MGR.PLAN_ID = MED.PLAN_ID
AND MED.EXCEPTION_TYPE IN (24
, 26
, 52
, 67)
AND ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = MED.EXCEPTION_TYPE
AND MTP.PARTNER_TYPE =3
AND MTP.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MED.ORGANIZATION_ID UNION ALL SELECT /*+ FIRST_ROWS */ MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.INVENTORY_ITEM_ID
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MTP.ORGANIZATION_CODE
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, MIF.ITEM_NAME
, MIF.DESCRIPTION
, MIF.BUYER_NAME
, MIF.PLANNER_CODE
, ML.MEANING
, NVL(MR.PROJECT_ID
, 0)
, NVL(MR.TASK_ID
, 0)
, NVL(MR.PLANNING_GROUP
, '0')
, MSC_GET_NAME.PROJECT(MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MR.TASK_ID
, MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MR.PLANNING_GROUP
, NULL
, NULL
, MR.NEW_SCHEDULE_DATE
, MED.DATE1
, MED.DATE2
, DECODE(MED.EXCEPTION_TYPE
, 9
, MR.SCHEDULE_COMPRESS_DAYS
, TO_NUMBER(NULL))
, MR.NEW_ORDER_QUANTITY
, NULL
, NVL(MR.ORDER_NUMBER
, TO_CHAR(MR.TRANSACTION_ID))
, NULL
, NULL
, NULL
, NULL
, MR.TRANSACTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, DECODE(MED.EXCEPTION_TYPE
, 37
, MED.QUANTITY
, 54
, MED.QUANTITY
, TO_NUMBER(NULL))
, NVL(MED.SUPPLIER_ID
, MR.SUPPLIER_ID)
, MSC_GET_NAME.SUPPLIER(NVL(MED.SUPPLIER_ID
, MR.SUPPLIER_ID))
, NVL(MED.SUPPLIER_SITE_ID
, MR.SUPPLIER_SITE_ID)
, MSC_GET_NAME.SUPPLIER_SITE(NVL(MED.SUPPLIER_SITE_ID
, MR.SUPPLIER_SITE_ID))
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, MED.NUMBER2
, MED.NUMBER4
, DECODE(MED.EXCEPTION_TYPE
, 54
, MSC_GET_NAME.ORG_CODE(MED.NUMBER2
, MED.NUMBER4)
, 57
, MSC_GET_NAME.ORG_CODE(MED.NUMBER2
, MED.NUMBER4)
, 59
, MSC_GET_NAME.ORG_CODE(MED.NUMBER2
, MED.NUMBER4)
, NULL)
, MR.NEW_SCHEDULE_DATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MR.OLD_SCHEDULE_DATE
, ML2.MEANING
, MR.ORDER_TYPE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MED.EXCEPTION_TYPE
, 37
, MED.NUMBER4
, 54
, MED.NUMBER4
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE( MED.EXCEPTION_TYPE
, 62
, MED.QUANTITY
, 66
, MED.QUANTITY
, TO_NUMBER(NULL))
, 1
, ML3.MEANING
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, DECODE( MED.EXCEPTION_TYPE
, 62
, MSC_GET_NAME.LOOKUP_MEANING ('RESOURCE_FIRM_TYPE'
, MED.NUMBER2)
, NULL)
, DECODE(MED.EXCEPTION_TYPE
, 57
, MP.PLAN_START_DATE + MED.NUMBER4
, 59
, MP.PLAN_START_DATE + MED.NUMBER4
, TO_DATE(NULL))
, DECODE(MED.EXCEPTION_TYPE
, 57
, MED.QUANTITY
, 59
, MED.QUANTITY
, TO_NUMBER(NULL))
, MR.NEW_DOCK_DATE
, DECODE(MED.EXCEPTION_TYPE
, 37
, MED.NUMBER4-MED.QUANTITY
, 54
, MED.NUMBER4 - MED.QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, DECODE(MED.EXCEPTION_TYPE
, 57
, MR.SHIP_METHOD
, 59
, MR.SHIP_METHOD
, NULL)
FROM MSC_EXCEPTION_DETAILS MED
, MSC_SYSTEM_ITEMS MIF
, MSC_ITEM_CATEGORIES MIC
, MSC_SUPPLIES MR
, MSC_TRADING_PARTNERS MTP
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MSC_PLANS MP
WHERE MIC.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND MIC.SR_INSTANCE_ID = MIF.SR_INSTANCE_ID
AND MIC.INVENTORY_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND MIF.INVENTORY_ITEM_ID = MED.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MED.ORGANIZATION_ID
AND MIF.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MIF.PLAN_ID = MED.PLAN_ID
AND MR.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MR.TRANSACTION_ID = MED.NUMBER1
AND MR.PLAN_ID = MED.PLAN_ID
AND MED.EXCEPTION_TYPE IN (9
, 37
, 54
, 57
, 59
, 62
, 66)
AND ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = MED.EXCEPTION_TYPE
AND MTP.PARTNER_TYPE =3
AND MTP.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MED.ORGANIZATION_ID
AND ML2.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND ML2.LOOKUP_CODE = MR.ORDER_TYPE
AND ML3.LOOKUP_TYPE = 'MSC_ORIGINATION_CODE_TYPE'
AND ML3.LOOKUP_CODE = 1
AND MP.PLAN_ID = MED.PLAN_ID UNION ALL SELECT /*+ FIRST_ROWS */ MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MR.INVENTORY_ITEM_ID
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MTP.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, ML.MEANING
, NVL(MR.PROJECT_ID
, 0)
, NVL(MR.TASK_ID
, 0)
, NVL(MR.PLANNING_GROUP
, '0')
, MSC_GET_NAME.PROJECT(MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MR.TASK_ID
, MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MR.PLANNING_GROUP
, NULL
, NULL
, MR.NEW_SCHEDULE_DATE
, MED.DATE1
, MED.DATE2
, TO_NUMBER(NULL)
, MR.NEW_ORDER_QUANTITY
, NULL
, NVL(MR.ORDER_NUMBER
, TO_CHAR(MR.TRANSACTION_ID))
, NULL
, NULL
, NULL
, NULL
, MR.TRANSACTION_ID
, TO_NUMBER(NULL)
, MDR.DEPARTMENT_ID
, MDR.RESOURCE_ID
, MDR.DEPARTMENT_CODE
, MDR.RESOURCE_CODE
, MDR.RESOURCE_TYPE
, ML2.MEANING
, MED.QUANTITY
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, ML3.MEANING
, MR.ORDER_TYPE
, MDR.BATCHABLE_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE( MED.EXCEPTION_TYPE
, 36
, MED.NUMBER4
, 53
, MED.NUMBER4
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MED.EXCEPTION_TYPE
, 63
, MED.QUANTITY
, TO_NUMBER(NULL))
, 1
, ML4.MEANING
, NULL
, DECODE( MED.EXCEPTION_TYPE
, 36
, MED.NUMBER2
, 53
, MED.NUMBER2
, 58
, MED.NUMBER2
, 60
, MED.NUMBER2
, 63
, MED.NUMBER3
, TO_NUMBER(NULL))
, DECODE( MED.EXCEPTION_TYPE
, 36
, MED.NUMBER2
, 53
, MED.NUMBER3
, 58
, MED.NUMBER3
, 60
, MED.NUMBER3
, 63
, MED.NUMBER4
, TO_NUMBER(NULL))
, DECODE( MED.EXCEPTION_TYPE
, 63
, MSC_GET_NAME.LOOKUP_MEANING('RESOURCE_FIRM_TYPE'
, MED.NUMBER2)
, NULL)
, DECODE(MED.EXCEPTION_TYPE
, 58
, MP.PLAN_START_DATE + MED.NUMBER4
, 60
, MP.PLAN_START_DATE + MED.NUMBER4
, TO_DATE(NULL))
, DECODE(MED.EXCEPTION_TYPE
, 58
, MED.QUANTITY
, 60
, MED.QUANTITY
, TO_NUMBER(NULL))
, MR.NEW_DOCK_DATE
, DECODE( MED.EXCEPTION_TYPE
, 36
, MED.NUMBER4 - MED.QUANTITY
, 53
, MED.NUMBER4 - MED.QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, NULL
FROM MSC_EXCEPTION_DETAILS MED
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_SYSTEM_ITEMS MSI
, MSC_SUPPLIES MR
, MSC_TRADING_PARTNERS MTP
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MSC_PLANS MP
WHERE MDR.DEPARTMENT_ID = MED.DEPARTMENT_ID
AND MDR.RESOURCE_ID = MED.RESOURCE_ID
AND MDR.ORGANIZATION_ID = MED.ORGANIZATION_ID
AND MDR.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MDR.PLAN_ID = MED.PLAN_ID
AND MR.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MR.TRANSACTION_ID = MED.NUMBER1
AND MR.PLAN_ID = MED.PLAN_ID
AND MSI.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MR.SR_INSTANCE_ID
AND MSI.PLAN_ID = MR.PLAN_ID
AND MED.EXCEPTION_TYPE IN (36
, 53
, 58
, 60
, 63)
AND ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = MED.EXCEPTION_TYPE
AND MTP.PARTNER_TYPE =3
AND MTP.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MED.ORGANIZATION_ID
AND ML2.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND ML2.LOOKUP_CODE = MDR.RESOURCE_TYPE
AND ML3.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND ML3.LOOKUP_CODE = MR.ORDER_TYPE
AND ML4.LOOKUP_TYPE = 'MSC_ORIGINATION_CODE_TYPE'
AND ML4.LOOKUP_CODE = 1
AND MP.PLAN_ID = MED.PLAN_ID UNION ALL SELECT /*+ FIRST_ROWS */ MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MR.INVENTORY_ITEM_ID
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MTP.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.BUYER_NAME
, MSI.PLANNER_CODE
, ML.MEANING
, NVL(MR.PROJECT_ID
, 0)
, NVL(MR.TASK_ID
, 0)
, NVL(MR.PLANNING_GROUP
, '0')
, MSC_GET_NAME.PROJECT(MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MR.TASK_ID
, MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MR.PLANNING_GROUP
, NULL
, NULL
, MR.NEW_SHIP_DATE
, MED.DATE1
, MED.DATE2
, TO_NUMBER(NULL)
, MED.NUMBER3
, NULL
, NVL(MR.ORDER_NUMBER
, TO_CHAR(MR.TRANSACTION_ID))
, NULL
, NULL
, NULL
, NULL
, MR.TRANSACTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, MED.QUANTITY
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, MED.NUMBER2
, MED.NUMBER4
, MSC_GET_NAME.ORG_CODE(MED.NUMBER2
, MED.NUMBER4)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, ML2.MEANING
, MR.ORDER_TYPE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MED.EXCEPTION_TYPE
, 55
, MSI.UNIT_WEIGHT * MR.NEW_ORDER_QUANTITY
, 56
, MSI.UNIT_VOLUME*MR.NEW_ORDER_QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 1
, ML3.MEANING
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, MR.NEW_DOCK_DATE
, DECODE(MED.EXCEPTION_TYPE
, 55
, MSI.UNIT_WEIGHT * MR.NEW_ORDER_QUANTITY - MED.QUANTITY
, 56
, MSI.UNIT_VOLUME*MR.NEW_ORDER_QUANTITY - MED.QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, MR.SHIP_METHOD
FROM MSC_EXCEPTION_DETAILS MED
, MSC_INTERORG_SHIP_METHODS MSIM
, MSC_SYSTEM_ITEMS MSI
, MSC_SUPPLIES MR
, MSC_TRADING_PARTNERS MTP
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
WHERE MSIM.TRANSACTION_ID = MED.DEPARTMENT_ID
AND MSIM.PLAN_ID = MED.PLAN_ID
AND MR.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MR.TRANSACTION_ID = MED.NUMBER1
AND MR.PLAN_ID = MED.PLAN_ID
AND MSI.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MR.SR_INSTANCE_ID
AND MSI.PLAN_ID = MR.PLAN_ID
AND MED.EXCEPTION_TYPE IN (55
, 56)
AND ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML.LOOKUP_CODE = MED.EXCEPTION_TYPE
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_INSTANCE_ID = MED.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MED.ORGANIZATION_ID
AND ML2.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND ML2.LOOKUP_CODE = MR.ORDER_TYPE
AND ML3.LOOKUP_TYPE = 'MSC_ORIGINATION_CODE_TYPE'
AND ML3.LOOKUP_CODE = 1

Columns

Name
EXCEPTION_ID
PLAN_ID
ORGANIZATION_ID
SR_INSTANCE_ID
INVENTORY_ITEM_ID
EXCEPTION_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ORGANIZATION_CODE
CATEGORY_SET_ID
CATEGORY_ID
CATEGORY_NAME
ITEM_SEGMENTS
ITEM_DESCRIPTION
BUYER_NAME
PLANNER_CODE
EXCEPTION_TYPE_TEXT
PROJECT_ID
TASK_ID
PLANNING_GROUP_HIDDEN
PROJECT_NUMBER
TASK_NUMBER
PLANNING_GROUP
TO_PROJECT_NUMBER
TO_TASK_NUMBER
DUE_DATE
FROM_DATE
TO_DATE
DAYS_COMPRESSED
QUANTITY
LOT_NUMBER
ORDER_NUMBER
SUPPLY_TYPE
END_ITEM_SEGMENTS
PLANNED_INVENTORY_POINT
END_ORDER_NUMBER
TRANSACTION_ID
DEMAND_ID
DEPARTMENT_ID
RESOURCE_ID
DEPARTMENT_LINE_CODE
RESOURCE_CODE
RESOURCE_TYPE
RESOURCE_TYPE_CODE
UTILIZATION_RATE
SUPPLIER_ID
SUPPLIER_NAME
SUPPLIER_SITE_ID
SUPPLIER_SITE
CUSTOMER_ID
CUSTOMER_NAME
CUSTOMER_SITE_ID
CUSTOMER_SITE
ORDER_PRIORITY
DMD_SATISFIED_DATE
SUBSTITUTE_COMPONENT
ALTERNATE_ROUTING_DESIGNATOR
ALTERNATE_BOM_DESIGNATOR
SOURCE_ORGANIZATION_ID
SOURCE_ORG_INSTANCE_ID
SOURCE_ORGANIZATION_CODE
REPLENISHMENT_DATE
END_PEGGING_ID
DEMAND_QUANTITY
OLD_DUE_DATE
ORDER_TYPE
ORDER_TYPE_ID
BATCHABLE_FLAG
MIN_CAPACITY
MAX_CAPACITY
BATCH_NUMBER
REQUIRED_CAPACITY
QUANTITY_BY_DUE_DATE
RESOURCE_OVER_UTIL_COST
ALLOCATED_PERCENTAGE
ACTUAL_PERCENTAGE
PERCENT_VARIANCE
DAYS_LATE
ORIGINATION_TYPE_ID
ORIGINATION_TYPE
DEMAND_CLASS
OPERATION_SEQ_NUM
RESOURCE_SEQ_NUM
FIRM_TYPE
MIN_START_TIME
MIN_LEAD_TIME
NEW_DOCK_DATE
AVAILABLE_CAPACITY
QTY_MISMATCH
SHIP_METHOD