View: MSC_EXC_DETAIL_RESOURCE_V

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

View Text

SELECT MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.DEPARTMENT_ID
, MDR.DEPARTMENT_CODE
, MED.RESOURCE_ID
, MDR.RESOURCE_CODE
, MTP.ORGANIZATION_CODE
, MDR.DEPARTMENT_CLASS
, MDR.RESOURCE_GROUP_NAME
, MED.DATE1
, MED.DATE2
, MED.QUANTITY
, MED.NUMBER1
, MED.NUMBER2
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_EXCEPTION_DETAILS MED
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_TRADING_PARTNERS MTP
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 MTP.PARTNER_TYPE=3
AND MTP.SR_TP_ID=MED.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID=MED.SR_INSTANCE_ID
AND MED.EXCEPTION_TYPE IN (21
, 22
, 45
, 46) UNION ALL SELECT MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.DEPARTMENT_ID
, MDR.DEPARTMENT_CODE
, MED.RESOURCE_ID
, MDR.RESOURCE_CODE
, MTP.ORGANIZATION_CODE
, MDR.DEPARTMENT_CLASS
, MDR.RESOURCE_GROUP_NAME
, MED.DATE1
, MED.DATE2
, MED.QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NVL(MS.ORDER_NUMBER
, MS.TRANSACTION_ID)
, MS.NEW_SCHEDULE_DATE
, MS.NEW_ORDER_QUANTITY
, MS.ORDER_TYPE
, ML.MEANING
, MS.PURCH_LINE_NUM
, MI.ITEM_NAME
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_EXCEPTION_DETAILS MED
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_TRADING_PARTNERS MTP
, MSC_SUPPLIES MS
, MSC_ITEMS MI
, MFG_LOOKUPS ML
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 MTP.PARTNER_TYPE=3
AND MTP.SR_TP_ID=MED.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID=MED.SR_INSTANCE_ID
AND MS.PLAN_ID=MED.PLAN_ID
AND MS.TRANSACTION_ID=MED.TRANSACTION_ID
AND MS.SR_INSTANCE_ID=MED.SR_INSTANCE_ID
AND MS.INVENTORY_ITEM_ID=MI.INVENTORY_ITEM_ID
AND ML.LOOKUP_CODE = MS.ORDER_TYPE
AND ML.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND MED.EXCEPTION_TYPE=36 UNION ALL SELECT MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.DEPARTMENT_ID
, MDR.DEPARTMENT_CODE
, MED.RESOURCE_ID
, MDR.RESOURCE_CODE
, MTP.ORGANIZATION_CODE
, MDR.DEPARTMENT_CLASS
, MDR.RESOURCE_GROUP_NAME
, MED.DATE1
, MED.DATE2
, MED.QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NVL(MD.ORDER_NUMBER
, MSC_GET_NAME.DESIGNATOR(MD.SCHEDULE_DESIGNATOR_ID))
, MD.USING_ASSEMBLY_DEMAND_DATE
, MD.USING_REQUIREMENT_QUANTITY
, MD.ORIGINATION_TYPE
, ML.MEANING
, MD.SALES_ORDER_LINE_ID
, MI.ITEM_NAME
, MI.BUYER_NAME
, MI.PLANNER_CODE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_EXCEPTION_DETAILS MED
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_TRADING_PARTNERS MTP
, MSC_DEMANDS MD
, MSC_SYSTEM_ITEMS MI
, MFG_LOOKUPS ML
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 MTP.PARTNER_TYPE=3
AND MTP.SR_TP_ID=MED.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID=MED.SR_INSTANCE_ID
AND MD.DEMAND_ID=MED.DEMAND_ID
AND MD.SR_INSTANCE_ID=MED.SR_INSTANCE_ID
AND MED.PLAN_ID=MD.PLAN_ID
AND MD.ORGANIZATION_ID=MI.ORGANIZATION_ID
AND MD.SR_INSTANCE_ID=MI.SR_INSTANCE_ID
AND MD.PLAN_ID=MI.PLAN_ID
AND MD.INVENTORY_ITEM_ID=MI.INVENTORY_ITEM_ID
AND ML.LOOKUP_CODE = MD.ORIGINATION_TYPE
AND ML.LOOKUP_TYPE = 'MSC_DEMAND_ORIGINATION'
AND MED.EXCEPTION_TYPE IN (23
, 35) UNION ALL SELECT MED.EXCEPTION_TYPE
, MED.EXCEPTION_DETAIL_ID
, MED.PLAN_ID
, MED.ORGANIZATION_ID
, MED.SR_INSTANCE_ID
, MED.DEPARTMENT_ID
, MISM.SHIP_METHOD
, -1
, NULL
, MTP.ORGANIZATION_CODE
, NULL
, NULL
, MED.DATE1
, MED.DATE2
, MED.QUANTITY
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_EXCEPTION_DETAILS MED
, MSC_INTERORG_SHIP_METHODS MISM
, MSC_TRADING_PARTNERS MTP
WHERE MISM.TRANSACTION_ID=MED.DEPARTMENT_ID
AND MISM.PLAN_ID=MED.PLAN_ID
AND MTP.PARTNER_TYPE=3
AND MTP.SR_TP_ID=MISM.FROM_ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID=MISM.SR_INSTANCE_ID
AND MED.EXCEPTION_TYPE IN (38
, 39
, 40
, 50
, 51)

Columns