[Home] [Help] [Dependency Information]
Object Name: | OKE_K_COMMUNICATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_COMMUNICATIONS_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database generated row identifier | |
K_HEADER_ID | NUMBER | Yes | Contract document unique identifier | |
COMMUNICATION_NUM | VARCHAR2 | (30) | Yes | User-entered number of contract communication |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
COMMUNICATION_DATE | DATE | Date of communication | ||
REASON_NAME | VARCHAR2 | (80) | Displayed name for communication reason | |
REASON_CODE | VARCHAR2 | (30) | Internal code for communication reason | |
TYPE_NAME | VARCHAR2 | (80) | Yes | Displayed name for communication type |
TYPE | VARCHAR2 | (30) | Communications type | |
K_PARTY_ID | NUMBER | Unique identifier for contract party | ||
PARTY_LOCATION | VARCHAR2 | (240) | Location of party against which the communication is logged | |
PARTY_ROLE | VARCHAR2 | (30) | Role of party against which the communication is logged | |
PARTY_CONTACT | VARCHAR2 | (302) | Party contact for the communication | |
ACTION_NAME | VARCHAR2 | (80) | Yes | Contract communication action name |
ACTION_CODE | VARCHAR2 | (30) | Contract communication action code | |
PRIORITY_NAME | VARCHAR2 | (80) | Displayed name for priority rating | |
PRIORITY_CODE | VARCHAR2 | (30) | Priority rating code | |
OWNER_NAME | VARCHAR2 | (240) | Communication owner | |
OWNER | NUMBER | Communication owner | ||
WF_ITEM_TYPE | VARCHAR2 | (8) | Contract communication action workflow item type | |
WF_PROCESS | VARCHAR2 | (30) | Contract communication action workflow process | |
WF_ITEM_KEY | VARCHAR2 | (240) | Contract communication action workflow item key | |
LINE_NUMBER | VARCHAR2 | (150) | Contract document line item number | |
K_LINE_ID | NUMBER | Contract document line item unique identifier | ||
DELIVERABLE_NUM | VARCHAR2 | (150) | Deliverable Number | |
DELIVERABLE_ID | NUMBER | Contract deliverable unique identifier | ||
FUNDING_SOURCE_ID | NUMBER | Funding source unique identifier | ||
FUNDING_REF1 | VARCHAR2 | (240) | Funding reference | |
FUNDING_REF2 | VARCHAR2 | (240) | Funding reference | |
FUNDING_REF3 | VARCHAR2 | (240) | Funding reference | |
CHG_REQUEST_NUM | VARCHAR2 | (30) | Contract change request number | |
CHG_REQUEST_ID | NUMBER | Contract change request unique identifier | ||
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
PROJECT_ID | NUMBER | System generated project unique identifier | ||
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
TASK_ID | NUMBER | System generated task unique identifier | ||
DELETE_IND | VARCHAR2 | (1) | reserved for futhure use | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield attribute context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield attribute | |
TEXT | CLOB | (4000) | Communications text |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, K_HEADER_ID
, COMMUNICATION_NUM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, COMMUNICATION_DATE
, REASON_NAME
, REASON_CODE
, TYPE_NAME
, TYPE
, K_PARTY_ID
, PARTY_LOCATION
, PARTY_ROLE
, PARTY_CONTACT
, ACTION_NAME
, ACTION_CODE
, PRIORITY_NAME
, PRIORITY_CODE
, OWNER_NAME
, OWNER
, WF_ITEM_TYPE
, WF_PROCESS
, WF_ITEM_KEY
, LINE_NUMBER
, K_LINE_ID
, DELIVERABLE_NUM
, DELIVERABLE_ID
, FUNDING_SOURCE_ID
, FUNDING_REF1
, FUNDING_REF2
, FUNDING_REF3
, CHG_REQUEST_NUM
, CHG_REQUEST_ID
, PROJECT_NUMBER
, PROJECT_ID
, TASK_NUMBER
, TASK_ID
, DELETE_IND
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TEXT
FROM APPS.OKE_K_COMMUNICATIONS_V;
APPS.OKE_K_COMMUNICATIONS_V is not referenced by any database object
|
|
|