[Home] [Help] [Dependency Information]
Object Name: | OKC_MASSCHANGE_REQ_DTLS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_MASSCHANGE_REQ_DTLS |
Subobject Name: | |
Status: | VALID |
It contains the details of the change requested in the mass change operation . In other words, this entity is specific to mass change only. It has following details:
Attribute name : what is to be changed. Currently following attributes are mass changable
Price List
Start Date
End Date
Contract Group
Bill To address
Ship To address
Contact Name
Sales Credit
Contract Ref #
Product alias
Contract alias
Coveragr Time
Reaction Time
Restore time
Old Value: the value to be changed from. It can be any of the following:
a specific non-null value
null
ALL (irrespective of the value, change is to be made)
New Value: the value to be changed to
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_MASSCHANGE_REQ_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OIE_ID |
OKC_MASSCHANGE_REQ_DTLS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique identifier of a record. | |
OIE_ID | NUMBER | Surrogate key used for primary unique identifiers | ||
OLE_ID | NUMBER | Foreign key to Operation Lines table (OKC_OPERATION_LINES.ID) | ||
ATTRIBUTE_NAME | VARCHAR2 | (30) | Yes | The Name of the Attribute that was changed by the operation. |
OLD_VALUE | VARCHAR2 | (240) | The old value to be changed in the mass change request. | |
NEW_VALUE | VARCHAR2 | (240) | The new value for the requested mass change operation. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Sequential Number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed | |
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 | |
SECURITY_GROUP_ID | NUMBER | Used in Hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OIE_ID
, OLE_ID
, ATTRIBUTE_NAME
, OLD_VALUE
, NEW_VALUE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM OKC.OKC_MASSCHANGE_REQ_DTLS;
OKC.OKC_MASSCHANGE_REQ_DTLS does not reference any database object
OKC.OKC_MASSCHANGE_REQ_DTLS is referenced by following:
|
|
|