VIEW: APPS.MRP_EXCEPTION_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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