[Home] [Help] [Dependency Information]
Object Name: | PO_LINES_REF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 | |
PO_LINE_NUM | NUMBER | Yes | Line number | |
LINE_TYPE_NAME | VARCHAR2 | (25) | Yes | Line Type Name |
PO_LINE_DESCRIPTION | VARCHAR2 | (240) | Item description. | |
PO_HEADER_ID | NUMBER | Yes | Document header unique identifier. | |
ORG_COST_OF_SALES_ACCOUNT | NUMBER | Cost of sales account | ||
ITEM_EXPENSE_ACCOUNT | NUMBER | Expense account | ||
EMPLOYEE_CHARGE_ACCOUNT | NUMBER | (15) | Identifies GL key flexfield structure. | |
ITEM_BUDGET_ACCOUNT | NUMBER | Encumbrance account | ||
ITEM_ASSET_FLAG | VARCHAR2 | (1) | Flag indicating item is an inventory asset | |
GLOBAL_AGREEMENT_ID | NUMBER | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line. | ||
GLOBAL_AGREEMENT_LINE_ID | NUMBER | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. | ||
POL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment. | |
POL_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
POL_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
POL_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
INVENTORY_ITEM | NUMBER | Inventory item identifier | ||
ITEM_REVISION | VARCHAR2 | (3) | Item revision. | |
ITEM_CATEGORY | NUMBER | Item category unique identifier. | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description. | |
CATEGORY_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ITEM_CATEGORY_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ITEM_CATEGORY_SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
ITEM_CATEGORY_SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
UNIT_PRICE | NUMBER | Unit price for the line. | ||
EXPENSE_ACCRUAL_CODE | VARCHAR2 | (25) | Accrual option for expense items |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, PO_LINE_NUM
, LINE_TYPE_NAME
, PO_LINE_DESCRIPTION
, PO_HEADER_ID
, ORG_COST_OF_SALES_ACCOUNT
, ITEM_EXPENSE_ACCOUNT
, EMPLOYEE_CHARGE_ACCOUNT
, ITEM_BUDGET_ACCOUNT
, ITEM_ASSET_FLAG
, GLOBAL_AGREEMENT_ID
, GLOBAL_AGREEMENT_LINE_ID
, POL_ATTRIBUTE_CATEGORY
, POL_ATTRIBUTE1
, POL_ATTRIBUTE2
, POL_ATTRIBUTE3
, POL_ATTRIBUTE4
, POL_ATTRIBUTE5
, POL_ATTRIBUTE6
, POL_ATTRIBUTE7
, POL_ATTRIBUTE8
, POL_ATTRIBUTE9
, POL_ATTRIBUTE10
, POL_ATTRIBUTE11
, POL_ATTRIBUTE12
, POL_ATTRIBUTE13
, POL_ATTRIBUTE14
, POL_ATTRIBUTE15
, POL_GLOBAL_ATTRIBUTE_CATEGORY
, POL_GLOBAL_ATTRIBUTE1
, POL_GLOBAL_ATTRIBUTE2
, POL_GLOBAL_ATTRIBUTE3
, POL_GLOBAL_ATTRIBUTE4
, POL_GLOBAL_ATTRIBUTE5
, POL_GLOBAL_ATTRIBUTE6
, POL_GLOBAL_ATTRIBUTE7
, POL_GLOBAL_ATTRIBUTE8
, POL_GLOBAL_ATTRIBUTE9
, POL_GLOBAL_ATTRIBUTE10
, POL_GLOBAL_ATTRIBUTE11
, POL_GLOBAL_ATTRIBUTE12
, POL_GLOBAL_ATTRIBUTE13
, POL_GLOBAL_ATTRIBUTE14
, POL_GLOBAL_ATTRIBUTE15
, POL_GLOBAL_ATTRIBUTE16
, POL_GLOBAL_ATTRIBUTE17
, POL_GLOBAL_ATTRIBUTE18
, POL_GLOBAL_ATTRIBUTE19
, POL_GLOBAL_ATTRIBUTE20
, INVENTORY_ITEM
, ITEM_REVISION
, ITEM_CATEGORY
, ITEM_DESCRIPTION
, CATEGORY_ATTRIBUTE_CATEGORY
, ITEM_CATEGORY_ATTRIBUTE1
, ITEM_CATEGORY_ATTRIBUTE2
, ITEM_CATEGORY_ATTRIBUTE3
, ITEM_CATEGORY_ATTRIBUTE4
, ITEM_CATEGORY_ATTRIBUTE5
, ITEM_CATEGORY_ATTRIBUTE6
, ITEM_CATEGORY_ATTRIBUTE7
, ITEM_CATEGORY_ATTRIBUTE8
, ITEM_CATEGORY_ATTRIBUTE9
, ITEM_CATEGORY_ATTRIBUTE10
, ITEM_CATEGORY_ATTRIBUTE11
, ITEM_CATEGORY_ATTRIBUTE12
, ITEM_CATEGORY_ATTRIBUTE13
, ITEM_CATEGORY_ATTRIBUTE14
, ITEM_CATEGORY_ATTRIBUTE15
, ITEM_CATEGORY_SEGMENT1
, ITEM_CATEGORY_SEGMENT2
, ITEM_CATEGORY_SEGMENT3
, ITEM_CATEGORY_SEGMENT4
, ITEM_CATEGORY_SEGMENT5
, ITEM_CATEGORY_SEGMENT6
, ITEM_CATEGORY_SEGMENT7
, ITEM_CATEGORY_SEGMENT8
, ITEM_CATEGORY_SEGMENT9
, ITEM_CATEGORY_SEGMENT10
, ITEM_CATEGORY_SEGMENT11
, ITEM_CATEGORY_SEGMENT12
, ITEM_CATEGORY_SEGMENT13
, ITEM_CATEGORY_SEGMENT14
, ITEM_CATEGORY_SEGMENT15
, ITEM_CATEGORY_SEGMENT16
, ITEM_CATEGORY_SEGMENT17
, ITEM_CATEGORY_SEGMENT18
, ITEM_CATEGORY_SEGMENT19
, ITEM_CATEGORY_SEGMENT20
, UNIT_PRICE
, EXPENSE_ACCRUAL_CODE
FROM APPS.PO_LINES_REF_V;
APPS.PO_LINES_REF_V is not referenced by any database object
|
|
|