[Home] [Help] [Dependency Information]
Object Name: | PO_OWNED_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_OWNED_LINES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_LINE_ID | NUMBER | Yes | Document line unique identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
LINE_TYPE_ID | NUMBER | Line type unique identifier | ||
LINE_NUM | NUMBER | Yes | Line number | |
OWNER_ID | NUMBER | (9) | Yes | Buyer unique identifier |
HEADER_TYPE_CODE | VARCHAR2 | (25) | Yes | Type of the document |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
ITEM_ID | NUMBER | Item unique identifier | ||
ITEM_REVISION | VARCHAR2 | (3) | Item revision number | |
CATEGORY_ID | NUMBER | Item class unique identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for quantity ordered | |
QUANTITY_COMMITTED | NUMBER | Quantity agreed for an agreement line | ||
COMMITTED_AMOUNT | NUMBER | Amount agreed for agreement lines | ||
ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates whethere or not you can change the price on releases | |
NOT_TO_EXCEED_PRICE | NUMBER | Price limit that you cannot exceed on a release shipment | ||
LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line | ||
UNIT_PRICE | NUMBER | Unit price for the line | ||
QUANTITY | NUMBER | Quantity ordered on the line | ||
UN_NUMBER_ID | NUMBER | UN number unique identifier | ||
HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
NOTE_TO_VENDOR | VARCHAR2 | (480) | Short note to vendor | |
FROM_HEADER_ID | NUMBER | Quotation unique identifier | ||
FROM_LINE_ID | NUMBER | Quotation line unique identifier | ||
MIN_ORDER_QUANTITY | NUMBER | Minimum order quantity for a quotation line | ||
MAX_ORDER_QUANTITY | NUMBER | Maximum order quantity for a quotation line | ||
QTY_RCV_TOLERANCE | NUMBER | Quantity received tolearnce percentage | ||
OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | (25) | Indicates whether you reject receipts exceeding the tolerance or not | |
MARKET_PRICE | NUMBER | Market price for the item on the line | ||
UNORDERED_FLAG | VARCHAR2 | (1) | Indicates whether the line was created from unordered receipts or not | |
CLOSED_CODE | VARCHAR2 | (25) | Closed type of the line | |
USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether the line is on hold or not | |
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the line is cancelled or not | |
CANCELLED_BY | NUMBER | (9) | Unique identifier of the employee who cancelled the line | |
CANCEL_DATE | DATE | Cancellation date | ||
CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by employee | |
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Firming status of the line (Unused since Version 7.0) | |
FIRM_DATE | DATE | Date the line becomes firmed (Unused since Version 7.0) | ||
VENDOR_PRODUCT_NUM | VARCHAR2 | (25) | Vendor product number | |
CONTRACT_NUM | VARCHAR2 | (25) | Contract number referenced on the line | |
TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether the document line is taxable or not | |
TYPE_1099 | VARCHAR2 | (10) | 1099 type for the purchase order line | |
CAPITAL_EXPENSE_FLAG | VARCHAR2 | (1) | Indicates whether the line is for a capital expense or not | |
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Indicates whether the buyer negotiated the price or not | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
REFERENCE_NUM | VARCHAR2 | (25) | Reference number (Unused since Version 7.0) | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TAX_CODE_ID | NUMBER | |||
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PO_HEADER_ID
, LINE_TYPE_ID
, LINE_NUM
, OWNER_ID
, HEADER_TYPE_CODE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED
, COMMITTED_AMOUNT
, ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT
, UNIT_PRICE
, QUANTITY
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, NOTE_TO_VENDOR
, FROM_HEADER_ID
, FROM_LINE_ID
, MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY
, QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG
, MARKET_PRICE
, UNORDERED_FLAG
, CLOSED_CODE
, USER_HOLD_FLAG
, CANCEL_FLAG
, CANCELLED_BY
, CANCEL_DATE
, CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, VENDOR_PRODUCT_NUM
, CONTRACT_NUM
, TAXABLE_FLAG
, TYPE_1099
, CAPITAL_EXPENSE_FLAG
, NEGOTIATED_BY_PREPARER_FLAG
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REFERENCE_NUM
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TAX_CODE_ID
, ORG_ID
FROM APPS.PO_OWNED_LINES;
APPS.PO_OWNED_LINES is not referenced by any database object
|
|
|