[Home] [Help]
View: MSC_NET_SUPPLY_SCHD_V
View Text
SELECT MFQ.QUERY_ID
, MFQ.CHAR4
, MFQ.CHAR1
, MFQ.CHAR2
, MFQ.CHAR3
, MFG.MEANING
, MFQ.LAST_UPDATE_DATE
, MFQ.LAST_UPDATED_BY
, MFQ.CREATION_DATE
, MFQ.CREATED_BY
, MFQ.LAST_UPDATE_LOGIN
FROM MSC_FORM_QUERY MFQ
, MFG_LOOKUPS MFG
WHERE MFG.LOOKUP_CODE=MFQ.NUMBER2
AND MFQ.NUMBER1=5
AND MFQ.NUMBER6=2
AND MFG.LOOKUP_TYPE='MRP_DESIGNATOR_TYPE_SHORT'
Columns
Name |
QUERY_ID |
PLAN_NAME |
ORG_CODE |
INPUT_NAME |
INPUT_SCHEDULE_DESC |
DESIGNATOR_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |