Use the Oracle Purchasing Lookups window to define lookup codes in Purchasing. Purchasing uses lookup codes to define lists of values throughout the system. A lookup category is called a lookup type, and the allowable values for the lookup type are called lookup codes. You can add your own codes to those initially provided for some of the lookup types, depending on your Access Level.

For example, Purchasing supplies the following Supplier Type codes: Employee and Supplier. You might want to define an additional code called Consultant to use for the purchase of consulting services.

Attention: You cannot change or delete codes once you have added and saved them, but you can change the code descriptions.

Enter one of the following predefined lookup Types: 1099 Supplier Exception, Acceptance Type, FOB (free on board), Freight Terms, Minority Group, Pay Group, PO/Requisition Reason, Price Type, Quotation Approval Reason, Reply/Receive Via, and Supplier Type.

Quality Inspection Codes
Use the Quality Inspection Codes window to define and update your inspection codes. You can define as many codes for inspection as you want. Each code must have a corresponding numerical ranking, which provides an inspection scale. You use these inspection codes when you receive and inspect the items you ordered.

Enter a Ranking number that corresponds to a specific quality code. This value must be between 0 and 100, where 0 represents the lowest quality. For example, 10 might represent a quality ranking of Poor, while 90 might represent a quality ranking of Excellent. Purchasing lists these rankings when you inspect your receipts.

Enter a Quality Code to indicate a particular quality standard. For example, you might want to define Excellent Condition or
Damaged as quality codes.