[Home] [Help]
[Dependency Information]
[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 | (14) | 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 | (14) | 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
OKC_K_HEADERS_B
OKC_K_ITEMS
OKC_K_LINES_B
OKC_K_LINES_TL
OKC_LINE_STYLES_B
OKC_STATUSES_B
OKL_K_LINES
APPS.OKL_LA_LN_ITM_UV is not referenced by any database object
|
|
|
|