DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_LINES_REF_V

Object Details
Object Name: PO_LINES_REF_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PO_LINES_REF_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES
SynonymMTL_DEFAULT_CATEGORY_SETS
SynonymMTL_ITEM_CATEGORIES
SynonymMTL_SYSTEM_ITEMS
ViewPER_EMPLOYEES_CURRENT_X
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES
SynonymPO_SYSTEM_PARAMETERS_ALL

APPS.PO_LINES_REF_V is not referenced by any database object