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_AM_QTE_UNITS_UV

Object Details

Object Name:	OKL_AM_QTE_UNITS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_QTE_UNITS_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	Comments
QUOTE_NUMBER	NUMBER		A unique identifier for each quote
QST_CODE	VARCHAR2	(30)	The quote status code
QTP_CODE	VARCHAR2	(30)	The quote type code
TQL_ID	NUMBER		Quote line identifier
TQD_ID	NUMBER		Quote identifier
ASSET_QUANTITY	NUMBER	(14)	Total number of asset units
QUOTE_QUANTITY	NUMBER	(14)	Total number of quote asset units
IB_LINE_ID	NUMBER		Install base asset line identifier
FIN_LINE_ID	NUMBER		Financial line asset identifier
DNZ_CHR_ID	NUMBER		Denormalized contract header identifier
SERIAL_NUMBER	VARCHAR2	(30)	Asset serial number
INSTANCE_QUANTITY	NUMBER		Instance quantity
INSTANCE_NUMBER	VARCHAR2	(30)	Instance number
ASSET_NUMBER	VARCHAR2	(150)	Asset number
ASSET_DESCRIPTION	VARCHAR2	(1995)	Asset description
LOCATION_DESCRIPTION	VARCHAR2	(80)	Location Description
QTE_ID	NUMBER		Quote identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUOTE_NUMBER
,      QST_CODE
,      QTP_CODE
,      TQL_ID
,      TQD_ID
,      ASSET_QUANTITY
,      QUOTE_QUANTITY
,      IB_LINE_ID
,      FIN_LINE_ID
,      DNZ_CHR_ID
,      SERIAL_NUMBER
,      INSTANCE_QUANTITY
,      INSTANCE_NUMBER
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      LOCATION_DESCRIPTION
,      QTE_ID
FROM APPS.OKL_AM_QTE_UNITS_UV;

Dependencies

[top of page]

APPS.OKL_AM_QTE_UNITS_UV references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; CSI_ITEM_INSTANCES; HZ_LOCATIONS; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_LINE_STYLES_B; OKL_TRX_QUOTES_B; OKL_TXD_QUOTE_LINE_DTLS; OKL_TXL_QTE_LINES_ALL_B; OKL_TXL_QUOTE_LINES_B

APPS.OKL_AM_QTE_UNITS_UV is not referenced by any database object