[Home] [Help] [Dependency Information]
Object Name: | OKL_LA_LN_ITM_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_LA_LN_ITM_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Yes | Covered asset line identifier | |
LINE_CLE_ID | NUMBER | Service line identifier | ||
LINE_STS_CODE | VARCHAR2 | (30) | Yes | Line status code |
LINE_CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
LINE_LINE_NUMBER | VARCHAR2 | (150) | Yes | Line number |
LINE_DISPLAY_SEQUENCE | NUMBER | (7) | Yes | Line display sequence |
LINE_LSE_ID | NUMBER | Yes | Line style identifier | |
LINE_START_DATE | DATE | Line effective from date | ||
LINE_END_DATE | DATE | Line effective to date | ||
LINE_PRICE_NEGOTIATED | NUMBER | Negotiated price for financial asset | ||
LINE_DNZ_CHR_ID | NUMBER | Yes | Denormalized contract header identifier | |
LINE_CHR_ID | NUMBER | Contract header identifier | ||
LINE_CAPITAL_AMOUNT | NUMBER | Capital amount | ||
ITEM_ID | NUMBER | Yes | Covered line item identifier | |
ITEM_CLE_ID | NUMBER | Yes | Covered item line identifier | |
ITEM_OBJECT1_ID1 | VARCHAR2 | (40) | Covered asset. Foreign key to OKC_K_LINES_B.ID for the financial asset line being covered | |
ITEM_OBJECT1_ID2 | VARCHAR2 | (200) | dummy component of foreign key to financial asset line | |
ITEM_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Covered asset jtf source object code | |
ITEM_NAME | VARCHAR2 | (150) | Covered asset number | |
ITEM_DESCRIPTION | VARCHAR2 | (1995) | Covered asset description | |
ITEM_CHR_ID | NUMBER | Covered Item record contract header identifier | ||
ITEM_DNZ_CHR_ID | NUMBER | Yes | Item record denormalized contract header identifier | |
ITEM_UOM_CODE | VARCHAR2 | (3) | Covered item unit of measure code | |
ITEM_EXCEPTION_YN | VARCHAR2 | (3) | Yes | Item exception flag |
ITEM_NUMBER_OF_ITEMS | NUMBER | Number of items | ||
LS_LTY_CODE | VARCHAR2 | (30) | Yes | Line style code |
LS_ID | NUMBER | Yes | Line style identifier | |
SERV_COV_PRD_ID | VARCHAR2 | (0) | Service contract covered product identifier | |
LINE_AMOUNT | NUMBER | Asset Line amount |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, LINE_CLE_ID
, LINE_STS_CODE
, LINE_CURRENCY_CODE
, LINE_LINE_NUMBER
, LINE_DISPLAY_SEQUENCE
, LINE_LSE_ID
, LINE_START_DATE
, LINE_END_DATE
, LINE_PRICE_NEGOTIATED
, LINE_DNZ_CHR_ID
, LINE_CHR_ID
, LINE_CAPITAL_AMOUNT
, ITEM_ID
, ITEM_CLE_ID
, ITEM_OBJECT1_ID1
, ITEM_OBJECT1_ID2
, ITEM_JTOT_OBJECT1_CODE
, ITEM_NAME
, ITEM_DESCRIPTION
, ITEM_CHR_ID
, ITEM_DNZ_CHR_ID
, ITEM_UOM_CODE
, ITEM_EXCEPTION_YN
, ITEM_NUMBER_OF_ITEMS
, LS_LTY_CODE
, LS_ID
, SERV_COV_PRD_ID
, LINE_AMOUNT
FROM APPS.OKL_LA_LN_ITM_UV;
APPS.OKL_LA_LN_ITM_UV is not referenced by any database object
|
|
|