VIEW: APPS.MSC_ACTION_SUMMARY_V

Source

View Text - Preformatted

SELECT MFQ.LAST_UPDATE_DATE , MFQ.LAST_UPDATED_BY , MFQ.CREATION_DATE , MFQ.CREATED_BY , MFQ.NUMBER2 , DECODE(MFQ.NUMBER16,null,mfq.number2,mfq.number16) , NULL , DECODE(mfq.number16,null,1,2) , mp.compile_designator , MFQ.number14 , MFQ.NUMBER4 , mfq.number15 , MFQ.NUMBER6 , MFQ.NUMBER7 ,nvl(to_char(number1), msc_get_name.lookup_meaning('MRP_EXCEPTION_VERSION', 1)) , MFQ.NUMBER5 ,MFQ.NUMBER3 ,MFQ.CHAR2 , MFQ.CHAR2 ,MFQ.NUMBER8 ,MFQ.CHAR14 ,MFQ.CHAR4 ,MFQ.CHAR4 ,MFQ.QUERY_ID ,msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE', MFQ.NUMBER2) ,nvl(mfq.char5, msc_get_name.item_name(mfq.number3,null,null,null)) ,MFQ.NUMBER11 ,msc_get_name.item_name(MFQ.NUMBER11, null, null, null) ,nvl(mfq.char6, msc_get_name.org_code(mfq.number4, mfq.number15)) ,msc_get_name.PROJECT(mfq.number6,mfq.number4, mfq.number14,mfq.number15) ,msc_get_name.TASK(mfq.number7, mfq.number6, mfq.number4, mfq.number14,mfq.number15) ,MFQ.CHAR9 ,MFQ.CHAR9 ,MFQ.CHAR3 ,MFQ.CHAR8 ,MFQ.NUMBER9 ,MFQ.NUMBER10 ,nvl(mfq.char7, msc_get_name.department_code(2, mfq.number9, mfq.number4, mfq.number14, mfq.number15)) ,nvl(mfq.char10, msc_get_name.resource_code(mfq.number10, mfq.number9, mfq.number4, mfq.number14,mfq.number15)) ,MFQ.CHAR11 ,MFQ.NUMBER12 ,msc_get_name.supplier(MFQ.NUMBER12) , MFQ.LAST_UPDATE_LOGIN , 1 , MFQ.ROWID , DECODE(NVL(number16,number2), 5,1, 6,2, 7,3, 3,4, 4,5, 2,6, 8,7, 1,8, 11,9, 10,10, 12,11, null) , DECODE(number16,NULL,-1,DECODE(number2, 41,1,35,2,42,3,23,4,15,5,16,6,13,7,14,8,24,9,26,10,25,11,27,12, 37,1,36,2,21,3,28,4,22,5, 40,1,38,2,39,3, 2,1,20,2,3,3, 10,1,7,2,8,3,6,4,9,5, 31,1,32,2,33,3,34,4,43,5,44,6, 17,1,19,2,18,3, 1,1,11,2,12,3,4,4,5,5, 86,1,85,2, 102,1,103,2,101,3,104,4,NULL)) , mfq.number13 ,mfq.request_id FROM msc_form_query MFQ, msc_plans mp WHERE mp.plan_id = mfq.number14

View Text - HTML Formatted

SELECT MFQ.LAST_UPDATE_DATE
, MFQ.LAST_UPDATED_BY
, MFQ.CREATION_DATE
, MFQ.CREATED_BY
, MFQ.NUMBER2
, DECODE(MFQ.NUMBER16
, NULL
, MFQ.NUMBER2
, MFQ.NUMBER16)
, NULL
, DECODE(MFQ.NUMBER16
, NULL
, 1
, 2)
, MP.COMPILE_DESIGNATOR
, MFQ.NUMBER14
, MFQ.NUMBER4
, MFQ.NUMBER15
, MFQ.NUMBER6
, MFQ.NUMBER7
, NVL(TO_CHAR(NUMBER1)
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_VERSION'
, 1))
, MFQ.NUMBER5
, MFQ.NUMBER3
, MFQ.CHAR2
, MFQ.CHAR2
, MFQ.NUMBER8
, MFQ.CHAR14
, MFQ.CHAR4
, MFQ.CHAR4
, MFQ.QUERY_ID
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MFQ.NUMBER2)
, NVL(MFQ.CHAR5
, MSC_GET_NAME.ITEM_NAME(MFQ.NUMBER3
, NULL
, NULL
, NULL))
, MFQ.NUMBER11
, MSC_GET_NAME.ITEM_NAME(MFQ.NUMBER11
, NULL
, NULL
, NULL)
, NVL(MFQ.CHAR6
, MSC_GET_NAME.ORG_CODE(MFQ.NUMBER4
, MFQ.NUMBER15))
, MSC_GET_NAME.PROJECT(MFQ.NUMBER6
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15)
, MSC_GET_NAME.TASK(MFQ.NUMBER7
, MFQ.NUMBER6
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15)
, MFQ.CHAR9
, MFQ.CHAR9
, MFQ.CHAR3
, MFQ.CHAR8
, MFQ.NUMBER9
, MFQ.NUMBER10
, NVL(MFQ.CHAR7
, MSC_GET_NAME.DEPARTMENT_CODE(2
, MFQ.NUMBER9
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15))
, NVL(MFQ.CHAR10
, MSC_GET_NAME.RESOURCE_CODE(MFQ.NUMBER10
, MFQ.NUMBER9
, MFQ.NUMBER4
, MFQ.NUMBER14
, MFQ.NUMBER15))
, MFQ.CHAR11
, MFQ.NUMBER12
, MSC_GET_NAME.SUPPLIER(MFQ.NUMBER12)
, MFQ.LAST_UPDATE_LOGIN
, 1
, MFQ.ROWID
, DECODE(NVL(NUMBER16
, NUMBER2)
, 5
, 1
, 6
, 2
, 7
, 3
, 3
, 4
, 4
, 5
, 2
, 6
, 8
, 7
, 1
, 8
, 11
, 9
, 10
, 10
, 12
, 11
, NULL)
, DECODE(NUMBER16
, NULL
, -1
, DECODE(NUMBER2
, 41
, 1
, 35
, 2
, 42
, 3
, 23
, 4
, 15
, 5
, 16
, 6
, 13
, 7
, 14
, 8
, 24
, 9
, 26
, 10
, 25
, 11
, 27
, 12
, 37
, 1
, 36
, 2
, 21
, 3
, 28
, 4
, 22
, 5
, 40
, 1
, 38
, 2
, 39
, 3
, 2
, 1
, 20
, 2
, 3
, 3
, 10
, 1
, 7
, 2
, 8
, 3
, 6
, 4
, 9
, 5
, 31
, 1
, 32
, 2
, 33
, 3
, 34
, 4
, 43
, 5
, 44
, 6
, 17
, 1
, 19
, 2
, 18
, 3
, 1
, 1
, 11
, 2
, 12
, 3
, 4
, 4
, 5
, 5
, 86
, 1
, 85
, 2
, 102
, 1
, 103
, 2
, 101
, 3
, 104
, 4
, NULL))
, MFQ.NUMBER13
, MFQ.REQUEST_ID
FROM MSC_FORM_QUERY MFQ
, MSC_PLANS MP
WHERE MP.PLAN_ID = MFQ.NUMBER14