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

VIEW: APPS.OKL_AM_QUOTE_PARTIES_UV

Object Details
Object Name: OKL_AM_QUOTE_PARTIES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AM_QUOTE_PARTIES_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
QUOTE_ID NUMBER
Yes
CONTRACT_ID NUMBER

QP_PARTY_ID NUMBER
Yes
QP_ROLE_CODE VARCHAR2 (30) Yes
QP_PARTY_ROLE VARCHAR2 (80)
QuickCode meaning
QP_DATE_SENT DATE

QP_DATE_HOLD VARCHAR2 (0)
QP_DELAY_DAYS NUMBER (4)
QP_ALLOCATION_PERCENTAGE NUMBER (5)
QP_EMAIL_ADDRESS VARCHAR2 (600)
QP_PARTY_OBJECT VARCHAR2 (30)
Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns.
QP_PARTY_ID1 VARCHAR2 (40)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
QP_PARTY_ID2 VARCHAR2 (200)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
QP_CONTACT_OBJECT VARCHAR2 (30)
Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns.
QP_CONTACT_ID1 VARCHAR2 (40)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
QP_CONTACT_ID2 VARCHAR2 (200)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
QP_CREATED_BY NUMBER (15) Yes
QP_CREATION_DATE DATE
Yes
QP_LAST_UPDATED_BY NUMBER (15) Yes
QP_LAST_UPDATE_DATE DATE
Yes
QP_LAST_UPDATE_LOGIN NUMBER (15)
KP_PARTY_ID NUMBER

Primary key column.
KP_ROLE_CODE VARCHAR2 (30)
Foreign key to FND_LOOKUPS.
KP_PARTY_ROLE VARCHAR2 (80)
QuickCode meaning
PO_PARTY_OBJECT VARCHAR2 (30)
Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns.
PO_PARTY_ID1 VARCHAR2 (40)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
PO_PARTY_ID2 VARCHAR2 (200)
Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
PARTY_NAME VARCHAR2 (4000)
CONTACT_NAME VARCHAR2 (4000)
Query Text

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


SELECT QUOTE_ID
,      CONTRACT_ID
,      QP_PARTY_ID
,      QP_ROLE_CODE
,      QP_PARTY_ROLE
,      QP_DATE_SENT
,      QP_DATE_HOLD
,      QP_DELAY_DAYS
,      QP_ALLOCATION_PERCENTAGE
,      QP_EMAIL_ADDRESS
,      QP_PARTY_OBJECT
,      QP_PARTY_ID1
,      QP_PARTY_ID2
,      QP_CONTACT_OBJECT
,      QP_CONTACT_ID1
,      QP_CONTACT_ID2
,      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_OBJECT
,      PO_PARTY_ID1
,      PO_PARTY_ID2
,      PARTY_NAME
,      CONTACT_NAME
FROM APPS.OKL_AM_QUOTE_PARTIES_UV;

Dependencies

[top of page]

APPS.OKL_AM_QUOTE_PARTIES_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewOKC_K_PARTY_ROLES_V
PL/SQL PackageOKL_AM_UTIL_PVT - show dependent code
ViewOKL_QUOTE_PARTIES_V
SynonymOKL_TRX_QUOTES_B
APPS.OKL_AM_QUOTE_PARTIES_UV is referenced by following:

SchemaAPPS
Package BodyOKL_AM_QUOTES_WF - show dependent code
ViewOKL_AM_QUOTE_PARTY_CONTACTS_UV
Package BodyOKL_AM_SEND_FULFILLMENT_PVT - show dependent code