[Home] [Help] [Dependency Information]
Object Name: | OKI_LICENSES_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 |
---|---|---|---|---|
ORDER_NUMBER | NUMBER | Yes | Order number | |
INSTANCE_ID | NUMBER | Yes | Install base Instance id | |
SYSTEM_ID | NUMBER | Install base system id | ||
INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance type code | |
LAST_OE_PO_NUMBER | VARCHAR2 | (50) | Last order PO number | |
LAST_OE_ORDER_LINE_ID | NUMBER | Last order PO line number | ||
LINE_ID | NUMBER | Yes | Line id | |
UNIT_LIST_PRICE | NUMBER | Unit list price | ||
UNIT_SELLING_PRICE | NUMBER | Unit selling price | ||
ORDERED_QUANTITY | NUMBER | Ordered quantity | ||
PRICING_QUANTITY | NUMBER | Pricing quantity | ||
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer PO number | |
SALESREP_ID | NUMBER | (15) | Salesperson id |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_NUMBER
, INSTANCE_ID
, SYSTEM_ID
, INSTANCE_TYPE_CODE
, LAST_OE_PO_NUMBER
, LAST_OE_ORDER_LINE_ID
, LINE_ID
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, ORDERED_QUANTITY
, PRICING_QUANTITY
, CUST_PO_NUMBER
, SALESREP_ID
FROM APPS.OKI_LICENSES_V;
APPS.OKI_LICENSES_V is not referenced by any database object
|
|
|