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_QUOTE_PARTY_CONTACTS_UV

Object Details

Object Name:	OKL_AM_QUOTE_PARTY_CONTACTS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_QUOTE_PARTY_CONTACTS_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
QTE_ID	VARCHAR2	(0)	Foreign key to view OKL_TRX_QUOTES_V
CONTRACT_ID	VARCHAR2	(0)
K_BUY_OR_SELL	VARCHAR2	(0)
QP_PARTY_ID	VARCHAR2	(0)
QP_ROLE_CODE	VARCHAR2	(0)
QP_PARTY_ROLE	VARCHAR2	(0)
QP_DATE_SENT	VARCHAR2	(0)
QP_DATE_HOLD	VARCHAR2	(0)
QP_CREATED_BY	VARCHAR2	(0)
QP_CREATION_DATE	VARCHAR2	(0)
QP_LAST_UPDATED_BY	VARCHAR2	(0)
QP_LAST_UPDATE_DATE	VARCHAR2	(0)
QP_LAST_UPDATE_LOGIN	VARCHAR2	(0)
KP_PARTY_ID	VARCHAR2	(0)
KP_ROLE_CODE	VARCHAR2	(0)
KP_PARTY_ROLE	VARCHAR2	(0)
PO_PARTY_ID1	VARCHAR2	(0)
PO_PARTY_ID2	VARCHAR2	(0)
PO_PARTY_OBJECT	VARCHAR2	(0)
PO_PARTY_NAME	VARCHAR2	(0)
PO_PARTY_DESC	VARCHAR2	(0)
CO_CONTACT_ID1	VARCHAR2	(0)
CO_CONTACT_ID2	VARCHAR2	(0)
CO_CONTACT_OBJECT	VARCHAR2	(0)
CO_CONTACT_NAME	VARCHAR2	(0)
CO_CONTACT_DESC	VARCHAR2	(0)
CO_EMAIL	VARCHAR2	(0)
CO_ORDER_NUM	VARCHAR2	(0)
CO_DATE_SENT	VARCHAR2	(0)
CP_POINT_ID	VARCHAR2	(0)
CP_POINT_TYPE	VARCHAR2	(0)
CP_PRIMARY_FLAG	VARCHAR2	(0)
CP_EMAIL	VARCHAR2	(0)
CP_DETAILS	VARCHAR2	(0)
CP_ORDER_NUM	VARCHAR2	(0)
CP_DATE_SENT	VARCHAR2	(0)

Query Text

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


SELECT QTE_ID
,      CONTRACT_ID
,      K_BUY_OR_SELL
,      QP_PARTY_ID
,      QP_ROLE_CODE
,      QP_PARTY_ROLE
,      QP_DATE_SENT
,      QP_DATE_HOLD
,      QP_CREATED_BY
,      QP_CREATION_DATE
,      QP_LAST_UPDATED_BY
,      QP_LAST_UPDATE_DATE
,      QP_LAST_UPDATE_LOGIN
,      KP_PARTY_ID
,      KP_ROLE_CODE
,      KP_PARTY_ROLE
,      PO_PARTY_ID1
,      PO_PARTY_ID2
,      PO_PARTY_OBJECT
,      PO_PARTY_NAME
,      PO_PARTY_DESC
,      CO_CONTACT_ID1
,      CO_CONTACT_ID2
,      CO_CONTACT_OBJECT
,      CO_CONTACT_NAME
,      CO_CONTACT_DESC
,      CO_EMAIL
,      CO_ORDER_NUM
,      CO_DATE_SENT
,      CP_POINT_ID
,      CP_POINT_TYPE
,      CP_PRIMARY_FLAG
,      CP_EMAIL
,      CP_DETAILS
,      CP_ORDER_NUM
,      CP_DATE_SENT
FROM APPS.OKL_AM_QUOTE_PARTY_CONTACTS_UV;

Dependencies

[top of page]

APPS.OKL_AM_QUOTE_PARTY_CONTACTS_UV references the following:

APPS: FND_GLOBAL - show dependent code; OKL_AM_QUOTE_PARTIES_UV; OKL_AM_UTIL_PVT - show dependent code

APPS.OKL_AM_QUOTE_PARTY_CONTACTS_UV is not referenced by any database object