1. Support Desk.
  2. Reports
  3. ERP Armor: Reports for ERP Cloud (OTBI)

What is Query 29: Line Types?

The table(s) covered in this query are described by Oracle as follows:
Contains information about the line types you use in your business. You need each row for each line type you use. Oracle Purchasing uses this information to provide default information when you create a document line using a line type. Oracle Purchasing also uses this information to control how you enter information on your document lines according to the line type you choose. ORDER_TYPE_LOOKUP_CODE is 'AMOUNT' for an amount-based line type or 'QUANTITY' for a quantity-based line type.

Sensitive Access Risk Rule ID:
PP136

Risk Description:  Line Types determine whether or not receipts are required for PO lines and Receipt Close %.  Access to change line types would allow someone to change this configuration which is often relied upon as a key control and is critical to the prevention of fraud.Q29_Line Types