[Home] [Help] [Dependency Information]
Object Name: | OKC_CHANGE_REQUESTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_CHANGE_REQUESTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
This could correspond with the Engineering Change Proposal (ECP) or other forms of requests for changes to a legal document's content (i.e. Change Order)
EXAMPLE
DEFINITION
An AMENDMENT is a subtype of CHANGE and is an alteration to a proposal, offering (as opposed to a MODIFICATION which alters an agreed and signed active contract, award)
EXAMPLE
MISCELLANEOUS
DEFINITION
A MODIFICATION is a subtype of CHANGE and is an alteration to an agreed and signed active contract, award (as opposed to an AMENDMENT which alters a proposal, offering)
EXAMPLE
addenda
endorsement
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Primary key column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
CHR_ID | NUMBER | Foreign key to OKC_K_HEADERS_B. | ||
CRS_CODE | VARCHAR2 | (30) | Surrogate key used for primary unique identifiers. | |
USER_ID | NUMBER | (15) | Unique user identifier. | |
NAME | VARCHAR2 | (150) | Yes | Change request name. |
DATETIME_REQUEST | DATE | Yes | Date and time of change request. | |
SHORT_DESCRIPTION | VARCHAR2 | (600) | User entered free format abbreviated text description. | |
EXTENDED_YN | VARCHAR2 | (3) | Indicates if the hour and date for receipt of offers is extended. | |
AUTHORITY | VARCHAR2 | (240) | Name of the authority by whom the change order is issued or a supplemental agreement is entered. | |
SIGNATURE_REQUIRED_YN | VARCHAR2 | (3) | Yes/No field denoting if signature is required. | |
DATETIME_APPROVED | DATE | Date and time change request was approved. | ||
DATETIME_REJECTED | DATE | Date and time change request was rejected. | ||
DATETIME_EFFECTIVE | DATE | Yes | Date and time change request is effective. | |
DATETIME_INEFFECTIVE | DATE | Date and time change request became ineffective. | ||
DATETIME_APPLIED | DATE | Date and time applied. | ||
VERSION_CONTRACT | VARCHAR2 | (3) | Contract version number | |
APPLIED_CONTRACT_VERSION | VARCHAR2 | (50) | Contract version number. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
CRT_TYPE | VARCHAR2 | (30) | Yes | Surrogate key used for primary unique identifiers. |
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
, SFWT_FLAG
, CHR_ID
, CRS_CODE
, USER_ID
, NAME
, DATETIME_REQUEST
, SHORT_DESCRIPTION
, EXTENDED_YN
, AUTHORITY
, SIGNATURE_REQUIRED_YN
, DATETIME_APPROVED
, DATETIME_REJECTED
, DATETIME_EFFECTIVE
, DATETIME_INEFFECTIVE
, DATETIME_APPLIED
, VERSION_CONTRACT
, APPLIED_CONTRACT_VERSION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CRT_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_CHANGE_REQUESTS_V;
|
|
|