[Home] [Help] [Dependency Information]
Object Name: | POR_VIEW_DIST_HEADER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_VIEW_DIST_HEADER_V |
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 |
---|---|---|---|---|
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 |
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;
APPS.POR_VIEW_DIST_HEADER_V is not referenced by any database object
|
|
|