Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Enhanced exception message |
Implementation/DBA Data: | APPS.MRP_EXCEPTION_SUMMARY_V |
SELECT MFQ.LAST_UPDATE_DATE
, MFQ.LAST_UPDATED_BY
, MFQ.CREATION_DATE
, MFQ.CREATED_BY
, NVL(MFQ.NUMBER2
, 0)
, MFQ.CHAR1
, NVL(MFQ.NUMBER4
, 0)
, NVL(MFQ.NUMBER6
, 0)
, NVL(MFQ.NUMBER7
, 0)
, NVL(TO_CHAR(MFQ.NUMBER1)
, ML1.MEANING)
, MFQ.NUMBER5
, NVL(MFQ.NUMBER3
, 0)
, MFQ.CHAR2
, NVL(MFQ.CHAR2
, TO_CHAR(0))
, NVL(MFQ.NUMBER8
, 0)
, MFQ.CHAR4
, NVL(MFQ.CHAR4
, TO_CHAR(0))
, MFQ.QUERY_ID
, ML.MEANING
, MFQ.CHAR5
, MFQ.CHAR6
, MRP_GET_PROJECT.PROJECT(MFQ.NUMBER6)
, MRP_GET_PROJECT.TASK(MFQ.NUMBER7)
, MFQ.CHAR9
, NVL(MFQ.CHAR9
, TO_CHAR(0))
, MFQ.NUMBER9
, MFQ.NUMBER10
, MFQ.NUMBER11
, NVL(DEPT.DEPARTMENT_CODE
, LINE.LINE_CODE)
, RES.RESOURCE_CODE
, MFQ.NUMBER12
, ML2.MEANING
, MFQ.LAST_UPDATE_LOGIN
, MFQ.NUMBER13
, MFQ.ROWID
FROM MRP_FORM_QUERY MFQ
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, BOM_DEPARTMENTS DEPT
, BOM_RESOURCES RES
, WIP_LINES LINE
WHERE ML.LOOKUP_CODE = MFQ.NUMBER2
AND ML.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML1.LOOKUP_CODE = 1
AND ML1.LOOKUP_TYPE = 'MRP_EXCEPTION_VERSION'
AND ML2.LOOKUP_CODE(+)=MFQ.NUMBER12
AND ML2.LOOKUP_TYPE(+)='BOM_RESOURCE_TYPE'
AND DEPT.DEPARTMENT_ID(+)=MFQ.NUMBER9
AND RES.RESOURCE_ID(+)=MFQ.NUMBER10
AND LINE.LINE_ID(+)=MFQ.NUMBER11
AND MFQ.NUMBER13=1