[Home] [Help] [Dependency Information]
Object Name: | OKL_QUOTE_PARTIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_QUOTE_PARTIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
The parties related to the quote, could be one or more OKL contract party roles
EXAMPLE
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
QTE_ID | NUMBER | Yes | Foreign key to table OKL_TRX_QUOTES_B | |
CPL_ID | NUMBER | Foreign key to table OKC_K_PARTY_ROLES_B | ||
DATE_SENT | DATE | The date the quote was sent to the quote party | ||
QPT_CODE | VARCHAR2 | (30) | Yes | The quote party type code. The FND lookup type is OKL_QUOTE_PARTY_TYPE |
DELAY_DAYS | NUMBER | (4) | Delay sending a quote by number of delay days | |
ALLOCATION_PERCENTAGE | NUMBER | (5) | Percentage to be billed to additional recipient | |
EMAIL_ADDRESS | VARCHAR2 | (600) | Primary email address | |
PARTY_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents a party object | |
PARTY_OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to a table or view identified by the corresponding PARTY_JTOT_OBJECT1_CODE column. First part of the primary key in the foreign table/view | |
PARTY_OBJECT1_ID2 | VARCHAR2 | (200) | Foreign key to a table or view identified by the corresponding PARTY_JTOT_OBJECT1_CODE column. Second part of the primary key in the foreign table/view | |
CONTACT_JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents a party contact object | |
CONTACT_OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to a table or view identified by the corresponding CONTACT_JTOT_OBJECT1_CODE column. First part of the primary key in the foreign table/view | |
CONTACT_OBJECT1_ID2 | VARCHAR2 | (200) | Foreign key to a table or view identified by the corresponding CONTACT_JTOT_OBJECT1_CODE column. Second part of the primary key in the foreign table/view | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, QTE_ID
, CPL_ID
, DATE_SENT
, QPT_CODE
, DELAY_DAYS
, ALLOCATION_PERCENTAGE
, EMAIL_ADDRESS
, PARTY_JTOT_OBJECT1_CODE
, PARTY_OBJECT1_ID1
, PARTY_OBJECT1_ID2
, CONTACT_JTOT_OBJECT1_CODE
, CONTACT_OBJECT1_ID1
, CONTACT_OBJECT1_ID2
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_QUOTE_PARTIES_V;
|
|
|