[Home] [Help] [Dependency Information]
Object Name: | OKI_CLICE_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
This view contains license lines detail information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLE_ID | NUMBER | Yes | Internal Identifier for Covered Lines | |
INSTANCE_ID | NUMBER | Yes | Pulled from Install Base. It gives the Unique ID that identifies an item unit instance ( Internally generated sequence number ) | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | Contract Number Modifier | |
COMPLETE_K_NUMBER | VARCHAR2 | (241) | Complete Contract Number. Formed by concatnating Contract Number and Contract Number Modifier | |
ORDER_NUMBER | NUMBER | Order Number for Contracts generated through Order Management | ||
SYSTEM_ID | NUMBER | Pulled from Install Base. Gives the System Identifier to which the Instance is a part of | ||
INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance Type Code | |
LAST_OE_PO_NUMBER | VARCHAR2 | (50) | Last Order Entry Purchase Order Number | |
LAST_OE_ORDER_LINE_ID | NUMBER | Pulled from Install Base. It gives the value of last Order Line Idetifier that touched the Customer Instance | ||
CURR_CODE | VARCHAR2 | (15) | Transactional Currency Code | |
CURR_CODE_F | VARCHAR2 | (15) | Functional Currency Code | |
CURR_CODE_G | VARCHAR2 | (15) | Primary Currency Code | |
CURR_CODE_SG | VARCHAR2 | (15) | Secondary Currency Code | |
UNIT_LIST_PRICE | NUMBER | Pulled from Order Entry, this column gives List price for an item | ||
UNIT_LIST_PRICE_F | NUMBER | List Price of an Item in Functional Currency | ||
UNIT_LIST_PRICE_G | NUMBER | List Price of an Item in Primary Currency | ||
UNIT_LIST_PRICE_SG | NUMBER | List price of an Item in Secondary Currency | ||
UNIT_SELLING_PRICE | NUMBER | Actual Price Charged to the customer, in transactional Currency | ||
UNIT_SELLING_PRICE_F | NUMBER | Actual Price Charged to the customer ,in Functional currency | ||
UNIT_SELLING_PRICE_G | NUMBER | Actual price charged to customer, in primary currency | ||
UNIT_SELLING_PRICE_SG | NUMBER | Actual price charged to customer, in secondary currency | ||
ORDERED_QUANTITY | NUMBER | Quantity Ordered , in Primary Unit of measure defined in Materials table mtl_system_items_b | ||
PRICING_QUANTITY | NUMBER | Pulled from Order entry table ,this column gives quantity based on pricing unit of measure | ||
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase order number | |
RESOURCE_ID | NUMBER | Yes | Resource unique identification number |
Cut, paste (and edit) the following text to query this object:
SELECT CLE_ID
, INSTANCE_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, COMPLETE_K_NUMBER
, ORDER_NUMBER
, SYSTEM_ID
, INSTANCE_TYPE_CODE
, LAST_OE_PO_NUMBER
, LAST_OE_ORDER_LINE_ID
, CURR_CODE
, CURR_CODE_F
, CURR_CODE_G
, CURR_CODE_SG
, UNIT_LIST_PRICE
, UNIT_LIST_PRICE_F
, UNIT_LIST_PRICE_G
, UNIT_LIST_PRICE_SG
, UNIT_SELLING_PRICE
, UNIT_SELLING_PRICE_F
, UNIT_SELLING_PRICE_G
, UNIT_SELLING_PRICE_SG
, ORDERED_QUANTITY
, PRICING_QUANTITY
, CUST_PO_NUMBER
, RESOURCE_ID
FROM APPS.OKI_CLICE_DTL_V;
APPS.OKI_CLICE_DTL_V is not referenced by any database object
|
|
|