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

VIEW: APPS.OKI_CLICE_DTL_V

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


This view contains license lines detail information


[View Source]

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

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;

Dependencies

[top of page]

APPS.OKI_CLICE_DTL_V references the following:

SchemaAPPS
PL/SQL PackageBIS_COMMON_PARAMETERS - show dependent code
SynonymCSI_ITEM_INSTANCES
SynonymJTF_RS_SALESREPS
SynonymOE_ORDER_LINES_ALL
PL/SQL PackageOKC_UTIL - show dependent code
ViewOKI_DBI_CLE_V

APPS.OKI_CLICE_DTL_V is not referenced by any database object