FND Design Data [Home] [Help]

View: MSC_NET_EXC_DETAIL_V

Product: MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data: ViewAPPS.MSC_NET_EXC_DETAIL_V
View Text

SELECT MED.QUERY_ID
, MED.EXCEPTION_DETAIL_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_GROUP
, MED.GROUP_BY
, MED.FROM_PLAN
, MED.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MED.STATUS
, MFG.MEANING
, MEDA.ORGANIZATION_CODE
, DECODE(MED.EXCEPTION_TYPE
, 23
, MEDA.CHAR5
, 35
, MEDA.CHAR5
, 36
, MEDA.CHAR5
, 21
, NULL
, 22
, NULL
, MEDA.CHAR1)
, DECODE(MED.EXCEPTION_TYPE
, 23
, MEDA.CHAR7
, 35
, MEDA.CHAR7
, 36
, MEDA.CHAR7
, MEDA.CHAR2)
, DECODE(MED.EXCEPTION_TYPE
, 23
, MEDA.CHAR8
, 35
, MEDA.CHAR8
, 36
, MEDA.CHAR8
, MEDA.CHAR3)
, NVL(MED.CHAR1
, DECODE(MED.EXCEPTION_TYPE
, 21
, NULL
, 22
, NULL
, 23
, NULL
, 35
, NULL
, 36
, NULL
, 38
, NULL
, 39
, NULL
, 50
, NULL
, 51
, NULL
, 40
, NULL
, 45
, NULL
, 46
, NULL
, MSC_NETCHANGE_PKG.CATEGORY_NAME(MEDA.ORGANIZATION_ID
, MEDA.SR_INSTANCE_ID
, MEDA.NUMBER1)))
, MED.CHAR2
, MEDA.CHAR6
, MEDA.CHAR7
, MEDA.CHAR8
, MEDA.CHAR9
, MEDA.CHAR10
, MEDA.CHAR11
, DECODE(MED.EXCEPTION_TYPE
, 19
, MEDA.CHAR12
, NULL)
, MEDA.CHAR13
, MEDA.QUANTITY
, MEDA.DATE1
, MEDA.DATE2
, MEDA.CHAR1
, MEDA.CHAR2
, MEDA.CHAR3
, MEDA.CHAR4
, DECODE(MED.EXCEPTION_TYPE
, 12
, MEDA.CHAR12
, NULL)
, ROUND(DECODE(MED.EXCEPTION_TYPE
, 9
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, 2)
, ROUND(DECODE(MED.EXCEPTION_TYPE
, 15
, MEDA.NUMBER4
, 16
, MEDA.NUMBER4
, 24
, MEDA.NUMBER4
, 26
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, 2)
, ROUND(DECODE(MED.EXCEPTION_TYPE
, 25
, MEDA.NUMBER4
, 27
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, 2)
, ROUND(DECODE(MED.EXCEPTION_TYPE
, 6
, MEDA.NUMBER4
, 7
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, 2)
, ROUND(DECODE(MED.EXCEPTION_TYPE
, 10
, MEDA.NUMBER4
, 13
, MEDA.NUMBER4
, 14
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, 2)
, MEDA.LOAD_RATIO
, DECODE(MED.EXCEPTION_TYPE
, 45
, MEDA.NUMBER3
, 46
, MEDA.NUMBER3
, TO_NUMBER(NULL))
, DECODE(MED.EXCEPTION_TYPE
, 45
, MEDA.NUMBER4
, 46
, MEDA.NUMBER4
, TO_NUMBER(NULL))
, MEDA.NUMBER5
, DECODE(MED.EXCEPTION_TYPE
, 19
, NULL
, MEDA.CHAR12)
, MEDA.DATE3
, MEDA.DATE4
, MEDA.NUMBER3
, DECODE(MED.EXCEPTION_TYPE
, 15
, MEDA.DATE1
, 16
, MEDA.DATE1
, MEDA.DATE5)
, DECODE(MED.EXCEPTION_TYPE
, 21
, MEDA.CHAR13
, 22
, MEDA.CHAR13
, 23
, MEDA.CHAR13
, 35
, MEDA.CHAR13
, 36
, MEDA.CHAR13
, 38
, MEDA.CHAR13
, 39
, MEDA.CHAR13
, 50
, MEDA.CHAR13
, 51
, MEDA.CHAR13
, 40
, MEDA.CHAR13
, 45
, MEDA.CHAR13
, 46
, MEDA.CHAR13
, MEDA.CHAR4)
, DECODE(MED.EXCEPTION_TYPE
, 21
, NULL
, 22
, NULL
, 23
, NULL
, 35
, NULL
, 36
, NULL
, 38
, NULL
, 39
, NULL
, 50
, NULL
, 51
, NULL
, 40
, NULL
, 45
, NULL
, 46
, NULL
, MEDA.CHAR5)
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_NEC_EXC_DTL_TEMP MED
, MSC_EXC_DETAILS_ALL MEDA
, MSC_PLANS MP
, MFG_LOOKUPS MFG
WHERE MFG.LOOKUP_TYPE='MRP_EXCEPTION_CODE_TYPE'
AND MFG.LOOKUP_CODE=MED.EXCEPTION_TYPE
AND MEDA.PLAN_ID = MED.PLAN_ID
AND MEDA.EXCEPTION_DETAIL_ID = MED.EXCEPTION_DETAIL_ID
AND MED.STATUS IS NOT NULL
AND MP.PLAN_ID=MED.PLAN_ID ORDER BY MED.EXCEPTION_TYPE
, MED.MATCH_ID
, MED.FROM_PLAN

Columns

Name
QUERY_ID
EXCEPTION_DETAIL_ID
EXCEPTION_TYPE
EXCEPTION_GROUP
GROUP_BY_NAME
PLAN_A
PLAN_ID
PLAN_NAME
STATUS
EXCEPTION_TYPE_TEXT
ORG_CODE
ITEM_NAME
BUYER_NAME
PLANNER_CODE
CATEGORY_NAME
CATEGORY_SET_NAME
ORDER_NUMBER
CUSTOMER
SUPPLIER_NAME
SUPPLIER_SITE_NAME
PROJECT_NUMBER
TASK_NUMBER
TO_PROJECT_NUMBER
TO_TASK_NUMBER
QUANTITY
FROM_DATE
TO_DATE
DEPARTMENT_CODE
RESOURCE_CODE
DEPARTMENT_CLASS
RESOURCE_GROUP
LOT_NUMBER
COMPRESSED_DAYS
DAYS_LATE
DAYS_EARLY
DAYS_RESCHEDULED
DAYS_PAST_DUE
LOAD_RATIO
BATCH_NUMBER
REQUIRED_CAPACITY
LINE_NUMBER
ALTERNATE_NAME
DUE_DATE
OLD_DUE_DATE
DEMAND_PRIORITY
DMD_SATISFIED_DATE
ORDER_TYPE_TEXT
ITEM_DESC
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN