Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_NET_DEMAND_SCHD_V |
SELECT MFQ.QUERY_ID
, MFQ.CHAR4
, MFQ.CHAR1
, MFQ.CHAR2
, MFQ.CHAR3
, MFG.MEANING
, MFQ.CHAR5
, MFQ.NUMBER4
, MFQ.NUMBER5
, 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=1
AND MFG.LOOKUP_TYPE='MRP_DESIGNATOR_TYPE_SHORT'