[Home] [Help] [Dependency Information]
Object Name: | IBY_TRANSMIT_VALUES |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_TRANSMIT_VALUES |
Subobject Name: | |
Status: | VALID |
IBY_TRANSMIT_VALUES stores the values for the parameters defined in IBY_TRANSMIT_PARAMETERS for a given transmission protocol. Each value is associated with a single transmission configuration in table IBY_TRANSMIT_VALUES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_TRANSMIT_VALUES_CID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSMIT_CONFIGURATION_ID |
IBY_TRANSMIT_VALUES_PCODE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSMIT_PARAMETER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSMIT_VALUE_ID | NUMBER | (15) | Yes | Unique internal Identifier for this record. Generated using a database sequence. |
TRANSMIT_CONFIGURATION_ID | NUMBER | (15) | Yes | Transmission configuration identifier |
TRANSMIT_PARAMETER_CODE | VARCHAR2 | (30) | Yes | Identifier of the transmission parameter for which this entry provides a value |
TRANSMIT_VARCHAR2_VALUE | VARCHAR2 | (255) | Value of the transmission parameter for this transmission configuration, if it is of type VARCHAR2 | |
TRANSMIT_NUMBER_VALUE | NUMBER | Value of the transmission parameter for this transmission configuration, if it is of type NUMBER | ||
TRANSMIT_DATE_VALUE | DATE | Value of the transmission parameter for this transmission configuration, if it is of type DATE | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application. |
VAL_SEC_SEGMENT_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSMIT_VALUE_ID
, TRANSMIT_CONFIGURATION_ID
, TRANSMIT_PARAMETER_CODE
, TRANSMIT_VARCHAR2_VALUE
, TRANSMIT_NUMBER_VALUE
, TRANSMIT_DATE_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, VAL_SEC_SEGMENT_ID
FROM IBY.IBY_TRANSMIT_VALUES;
IBY.IBY_TRANSMIT_VALUES does not reference any database object
IBY.IBY_TRANSMIT_VALUES is referenced by following:
|
|
|