Oracle Apps Manufacturing standard codes and their meanings

PROMPT MANUFACTURING

PROMPT Find standard codes and their meanings

SELECT   lookup_type, lookup_code, SUBSTR (meaning, 1, 60) "Meaning"

  FROM mfg_lookups

 WHERE UPPER (lookup_type) LIKE UPPER ('%'||NVL ('&YourType', 'N/A') || '%')

      OR lookup_type IN ('SERIAL_NUM_STATUS',

                        'MTL_PRIMARY_COST',

                        'MTL_CC_ENTRY_STATUSES',

                        'MTL_TXN_REQUEST_STATUS',

                        'MOVE_ORDER_TYPE'

                       )

ORDER BY lookup_type, lookup_code;