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

VIEW: APPS.POR_VIEW_DIST_HEADER_V

Object Details
Object Name: POR_VIEW_DIST_HEADER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_VIEW_DIST_HEADER_V
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
REQUISITION_LINE_ID NUMBER
Yes Requisition line unique identifier
LINE_NUMBER NUMBER
Yes Line number
ITEM_NUMBER VARCHAR2 (40)
Item number
CATEGORY VARCHAR2 (163)
Item category
DESCRIPTION VARCHAR2 (240) Yes Item description
UNIT_PRICE NUMBER

Unit price in functional currency
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
QUANTITY NUMBER

Quantity ordered
RATE_PER_UNIT NUMBER

Unit price
SERVICE_COST NUMBER

Service cost
EXTENDED_PRICE VARCHAR2 (4000)
Extended price for the line
LINE_TYPE_ID NUMBER
Yes Line type
CATALOG_TYPE VARCHAR2 (30)
Catalog type
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUISITION_LINE_ID
,      LINE_NUMBER
,      ITEM_NUMBER
,      CATEGORY
,      DESCRIPTION
,      UNIT_PRICE
,      UNIT_OF_MEASURE
,      QUANTITY
,      RATE_PER_UNIT
,      SERVICE_COST
,      EXTENDED_PRICE
,      LINE_TYPE_ID
,      CATALOG_TYPE
FROM APPS.POR_VIEW_DIST_HEADER_V;

Dependencies

[top of page]

APPS.POR_VIEW_DIST_HEADER_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_CURRENCY - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS
SynonymPO_REQUISITION_LINES

APPS.POR_VIEW_DIST_HEADER_V is not referenced by any database object