eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_LA_SERV_INTGR_UV

Object Details

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

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.OKL_LA_SERV_INTGR_UV references the following:

APPS: MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_TL; OKC_K_HEADERS_B; OKC_K_HEADERS_TL; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_PARTY_ROLES_B; OKC_K_REL_OBJS; OKC_LINE_STYLES_B; OKL_K_LINES; PO_VENDORS

APPS.OKL_LA_SERV_INTGR_UV is referenced by following:

APPS: OKL_K_LINE_FIN_EXT_PVT - show dependent code