PO_LINE_TYPES_B
PO_LINE_TYPES_B 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. . .
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PO_LINE_TYPES_B_PK |
LINE_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| LINE_TYPE_ID | NUMBER | 18 | Yes | Line type unique identifier | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity ordered. (Referencces INV_UNITS_OF_MEASURE.uom_code) | |||
| OUTSIDE_OPERATION_FLAG | VARCHAR2 | 1 | OUTSIDE_OPERATION_FLAG | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Type of order line | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CATEGORY_ID | NUMBER | 18 | Item class | |||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Default unit of measure | |||
| UNIT_PRICE | NUMBER | Default unit price | ||||
| RECEIVING_FLAG | VARCHAR2 | 1 | Default receipt required flag | |||
| INACTIVE_DATE | DATE | Inactive date for record | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchasing Line Types (PO_LINE_TYPES) | |||
| RECEIVE_CLOSE_TOLERANCE | NUMBER | Receive close tolerance | ||||
| PURCHASE_BASIS | VARCHAR2 | 30 | Yes | Purchase basis lookup type | ||
| MATCHING_BASIS | VARCHAR2 | 30 | Yes | Matching basis lookup type | ||
| INSPECTION_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether shipment must be inspected before the invoice is paid | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| MATCH_OPTION | VARCHAR2 | 25 | Possible values are P,R, and Null; P for Purchase Order and R for Receipt | |||
| LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | Stores a unique code to identify the line type. These code values are used to uniquely identify the rows as an alternate key for setup migrator as line_type_id is a surrogate key and can not be used for this purpose. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| PRODUCT_TYPE | VARCHAR2 | 30 | This value on the line type is used to default Product Type on PO Schedules. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | ||
| CREDIT_FLAG | VARCHAR2 | 1 | Indicates whether the line type can be used to create credit lines. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_LINE_TYPES_B | egp_categories_b | CATEGORY_ID |
| po_lines_archive_all | po_line_types_b | LINE_TYPE_ID |
| por_req_bu_options_all | po_line_types_b | LINE_TYPE_ID |
| po_lines_all | po_line_types_b | LINE_TYPE_ID |
| po_lines_draft_all | po_line_types_b | LINE_TYPE_ID |
| pon_auction_item_prices_all | po_line_types_b | LINE_TYPE_ID |
| po_system_parameters_all | po_line_types_b | LINE_TYPE_ID |
| po_line_types_tl | po_line_types_b | LINE_TYPE_ID |
| por_smart_forms_all_b | po_line_types_b | LINE_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_LINE_TYPES_B_U1 | Unique | Default | LINE_TYPE_ID, ORA_SEED_SET1 |
| PO_LINE_TYPES_B_U11 | Unique | Default | LINE_TYPE_ID, ORA_SEED_SET2 |
| PO_LINE_TYPES_B_U2 | Unique | Default | LINE_TYPE_CODE, ORA_SEED_SET1 |
| PO_LINE_TYPES_B_U21 | Unique | Default | LINE_TYPE_CODE, ORA_SEED_SET2 |