[Home] [Help] [Dependency Information]
Object Name: | OKL_LA_SERV_INTGR_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_LA_SERV_INTGR_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 |
---|---|---|---|---|
CLE_ID | NUMBER | Yes | Contract line identifier | |
START_DATE | DATE | Effective from date | ||
END_DATE | DATE | Effective to date | ||
ITEM_NAME | VARCHAR2 | (40) | Service item name | |
SUPPLIER_NAME | VARCHAR2 | (240) | Service supplier name | |
DNZ_CHR_ID | NUMBER | Yes | Denormalized contract header identifier | |
SERVICE_CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contracts for service contract number |
K_REL_OBJS_ID | NUMBER | Yes | contract relation identifier | |
K_REL_OBJS_CLE_ID | NUMBER | Related lease contract service line identifier | ||
K_REL_OBJS_CHR_ID | NUMBER | Related lease contract header identifier | ||
K_REL_OBJS_RTY_CODE | VARCHAR2 | (30) | Yes | Relationship code between lease contract service line and service contract |
K_REL_OBJS_OBJECT1_ID1 | VARCHAR2 | (40) | Related service contract identifier | |
K_REL_OBJS_OBJECT1_ID2 | VARCHAR2 | (200) | Related service contract identifier | |
K_REL_OBJS_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | JTF object source code for service contract header | |
L_REL_OBJS_ID | NUMBER | Yes | Line relation identifier | |
L_REL_OBJS_CLE_ID | NUMBER | Related lease contract service line identifier | ||
L_REL_OBJS_CHR_ID | NUMBER | Related lease contract header identifier | ||
L_REL_OBJS_RTY_CODE | VARCHAR2 | (30) | Yes | Relationship code between lease contract service line and service contract line |
L_REL_OBJS_OBJECT1_ID1 | VARCHAR2 | (40) | Related service contract line identifier | |
L_REL_OBJS_OBJECT1_ID2 | VARCHAR2 | (200) | Related service contract line identifier | |
L_REL_OBJS_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | JTF object source code for service contract line | |
AMOUNT | NUMBER | Service amount | ||
AUTHORING_ORG_ID | CHAR | (16) | Operating unit identifier | |
INV_ORGANIZATION_ID | CHAR | (19) | Lease contracts item validation inventory organization identifier | |
CURRENCY_CODE | CHAR | (13) | Currency code | |
CUST_OBJECT1_ID1 | CHAR | (16) | Customer account identifier | |
CUST_OBJECT1_ID2 | CHAR | (16) | Customer account identifier | |
BTO_OBJECT1_ID1 | CHAR | (15) | Bill to site use identifier | |
BTO_OBJECT1_ID2 | CHAR | (15) | Bill to site use identifier | |
SUPPLIER_NUMBER | VARCHAR2 | (30) | Yes | Supplier Number |
SUPPLIER_ID | NUMBER | Yes | Supplier ID |
Cut, paste (and edit) the following text to query this object:
SELECT CLE_ID
, START_DATE
, END_DATE
, ITEM_NAME
, SUPPLIER_NAME
, DNZ_CHR_ID
, SERVICE_CONTRACT_NUMBER
, K_REL_OBJS_ID
, K_REL_OBJS_CLE_ID
, K_REL_OBJS_CHR_ID
, K_REL_OBJS_RTY_CODE
, K_REL_OBJS_OBJECT1_ID1
, K_REL_OBJS_OBJECT1_ID2
, K_REL_OBJS_JTOT_OBJECT1_CODE
, L_REL_OBJS_ID
, L_REL_OBJS_CLE_ID
, L_REL_OBJS_CHR_ID
, L_REL_OBJS_RTY_CODE
, L_REL_OBJS_OBJECT1_ID1
, L_REL_OBJS_OBJECT1_ID2
, L_REL_OBJS_JTOT_OBJECT1_CODE
, AMOUNT
, AUTHORING_ORG_ID
, INV_ORGANIZATION_ID
, CURRENCY_CODE
, CUST_OBJECT1_ID1
, CUST_OBJECT1_ID2
, BTO_OBJECT1_ID1
, BTO_OBJECT1_ID2
, SUPPLIER_NUMBER
, SUPPLIER_ID
FROM APPS.OKL_LA_SERV_INTGR_UV;
|
|
|