FND Design Data [Home] [Help]

View: OKL_AM_QUOTE_PARTY_CONTACTS_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_AM_QUOTE_PARTY_CONTACTS_UV
View Text

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

Columns

Name
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