[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_T_TXN_LINE_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | CSI |
| FND Design Data: |  CSI.CSI_T_TXN_LINE_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
Transaction Details : Details about the Source Transaction Lines. Many - One between a transaction line and the transaction line details
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CSI_T_TXN_LINE_DETAILS_U01 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TXN_LINE_DETAIL_ID
|
| CSI_T_TXN_LINE_DETAILS_N01 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_LINE_ID
|
| CSI_T_TXN_LINE_DETAILS_N02 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INSTANCE_ID
|
| CSI_T_TXN_LINE_DETAILS_N03 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
INV_ORGANIZATION_ID
|
| CSI_T_TXN_LINE_DETAILS_N04 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CSI_SYSTEM_ID
|
| CSI_T_TXN_LINE_DETAILS_N05 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
SERIAL_NUMBER
LOT_NUMBER
|
| CSI_T_TXN_LINE_DETAILS_N06 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUB_TYPE_ID
|
| CSI_T_TXN_LINE_DETAILS_N07 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROCESSING_STATUS
|
| CSI_T_TXN_LINE_DETAILS_N08 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONFIG_INST_HDR_ID
CONFIG_INST_ITEM_ID
|
| CSI_T_TXN_LINE_DETAILS_N09 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOCATION_ID
LOCATION_TYPE_CODE
|
| CSI_T_TXN_LINE_DETAILS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INSTALL_LOCATION_ID
INSTALL_LOCATION_TYPE_CODE
|
| CSI_T_TXN_LINE_DETAILS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_TXN_LINE_DETAIL_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TXN_LINE_DETAIL_ID | NUMBER | Yes | Primary Key | |
| TRANSACTION_LINE_ID | NUMBER | Yes | Primary key | |
| INSTANCE_EXISTS_FLAG | VARCHAR2 | (1) | Is an Instance referenced in the Line Detail ? | |
| SOURCE_TRANSACTION_FLAG | VARCHAR2 | (1) | Yes | Is this Item on the source transaction line ? |
| INSTANCE_ID | NUMBER | FK to CSI_ITEM_INSTANCES | ||
| CSI_SYSTEM_ID | NUMBER | FK to CSI_SYSTEMS_B | ||
| INVENTORY_ITEM_ID | NUMBER | FK to MTL_SYSTEM_ITEMS | ||
| INV_ORGANIZATION_ID | NUMBER | Master INV Organization ID | ||
| INVENTORY_REVISION | VARCHAR2 | (3) | FK to MTL_ITEM_REVISIONS | |
| INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance Type - CSI Lookup | |
| ITEM_CONDITION_ID | NUMBER | FK to MTL_MATERIAL_STATUSES_B | ||
| QUANTITY | NUMBER | Quantity | ||
| UNIT_OF_MEASURE | VARCHAR2 | (3) | UOM Code | |
| QTY_REMAINING | NUMBER | Quantity - Computational | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | FK to MTL_SERIAL_NUMBERS | |
| LOT_NUMBER | VARCHAR2 | (80) | FK to MTL_LOT_NUMBERS | |
| MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Is the Serial Number the Manufacturer's? | |
| LOCATION_TYPE_CODE | VARCHAR2 | (30) | Installation Location Type - HZ_PARTY_SITES | |
| LOCATION_ID | NUMBER | Installation Location - HZ PARTY_SITE_ID | ||
| INSTALLATION_DATE | DATE | Installation Date | ||
| IN_SERVICE_DATE | DATE | In Service Date | ||
| EXTERNAL_REFERENCE | VARCHAR2 | (50) | External Reference (Ex: A Tag Number) | |
| VERSION_LABEL | VARCHAR2 | (30) | Version Label for the instance (Ex: As-Shipped) | |
| TRANSACTION_SYSTEM_ID | NUMBER | FK to CSI_T_TXN_SYSTEMS | ||
| SELLABLE_FLAG | VARCHAR2 | (1) | Is the Item Sellable ? | |
| ACTIVE_START_DATE | DATE | Activation Start Date. | ||
| ACTIVE_END_DATE | DATE | Activation End Date. | ||
| PRESERVE_DETAIL_FLAG | VARCHAR2 | (1) | Preserve the record when the source reference key changes | |
| CHANGED_INSTANCE_ID | NUMBER | FK to CSI_ITEM_INSTANCES | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Columns | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Columns | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
| CREATION_DATE | DATE | Yes | Standard WHO Columns | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Columns |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Columns | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Columns | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number ( for Stateless Applications) | |
| SECURITY_GROUP_ID | NUMBER | Security Group ID | ||
| CONTEXT | VARCHAR2 | (30) | Standard DFF Columns | |
| SUB_TYPE_ID | NUMBER | Yes | IB Transaction Type ID (Loaner , Advance Replacement , Sell etc) | |
| CSI_TRANSACTION_ID | NUMBER | CSI Transaction ID from Installed Base | ||
| PROCESSING_STATUS | VARCHAR2 | (30) | Status of the Set of Transaction Line Details entered for the source Line. | |
| ERROR_CODE | VARCHAR2 | (240) | error code - if the transaction fails in the interface process | |
| ERROR_EXPLANATION | VARCHAR2 | (240) | error explanation - if the transaction fails in the interface process | |
| REFERENCE_SOURCE_ID | NUMBER | Any Reference source document (Ex: RMA Line ID in case of Replacement transactions etc) | ||
| REFERENCE_SOURCE_DATE | DATE | Reference source date of the document above | ||
| RETURN_BY_DATE | DATE | Expected Return Date (ex: in case of loaners) | ||
| SOURCE_TXN_LINE_DETAIL_ID | NUMBER | Parent Txn Line detail ID, if any - FK to CSI_T_TXN_LINE_DETAILS | ||
| INV_MTL_TRANSACTION_ID | NUMBER | Inv material transaction id (especially in case of sales order issue transactions ..) | ||
| REQUEST_ID | NUMBER | Party / Account Merge | ||
| PROGRAM_APPLICATION_ID | NUMBER | Party / Account Merge | ||
| PROGRAM_ID | NUMBER | Party / Account Merge | ||
| PROGRAM_UPDATE_DATE | DATE | Party / Account Merge | ||
| MIGRATED_FLAG | VARCHAR2 | (1) | Flag indicating if the record is created as a part of migration. | |
| INSTALL_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Installation Location Type Code. | |
| INSTALL_LOCATION_ID | NUMBER | Installation Location Identifier. | ||
| CONFIG_INST_HDR_ID | NUMBER | Configuration Instance Header Identifier from Configurator. | ||
| CONFIG_INST_REV_NUM | NUMBER | Configuration Instance Revision Number from Configurator. | ||
| CONFIG_INST_ITEM_ID | NUMBER | Configuration Instance Item Identifier from Configurator. | ||
| CONFIG_INST_BASELINE_REV_NUM | NUMBER | Configuration Instance Base line Revision Number from Configurator. | ||
| TARGET_COMMITMENT_DATE | DATE | Target Commitment Date. For future use. | ||
| INSTANCE_DESCRIPTION | VARCHAR2 | (240) | Instance Description. | |
| REFERENCE_SOURCE_LINE_ID | NUMBER | Reference source document Line (Ex: RMA Line ID in case of RMA Fulfillment ) | ||
| INSTANCE_STATUS_ID | NUMBER | Item instance status id | ||
| CASCADE_OWNER_FLAG | VARCHAR2 | (1) | Flag to specify cascading of ownership to components | |
| PARENT_INSTANCE_ID | NUMBER | Parent item instance id | ||
| ASSC_TXN_LINE_DETAIL_ID | NUMBER | Associated source transaction details line id for a any given non source transaction details line. | ||
| OVERRIDING_CSI_TXN_ID | NUMBER | For TSO with Equipment return CSI transaction. |
Cut, paste (and edit) the following text to query this object:
SELECT TXN_LINE_DETAIL_ID
, TRANSACTION_LINE_ID
, INSTANCE_EXISTS_FLAG
, SOURCE_TRANSACTION_FLAG
, INSTANCE_ID
, CSI_SYSTEM_ID
, INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID
, INVENTORY_REVISION
, INSTANCE_TYPE_CODE
, ITEM_CONDITION_ID
, QUANTITY
, UNIT_OF_MEASURE
, QTY_REMAINING
, SERIAL_NUMBER
, LOT_NUMBER
, MFG_SERIAL_NUMBER_FLAG
, LOCATION_TYPE_CODE
, LOCATION_ID
, INSTALLATION_DATE
, IN_SERVICE_DATE
, EXTERNAL_REFERENCE
, VERSION_LABEL
, TRANSACTION_SYSTEM_ID
, SELLABLE_FLAG
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, PRESERVE_DETAIL_FLAG
, CHANGED_INSTANCE_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, CONTEXT
, SUB_TYPE_ID
, CSI_TRANSACTION_ID
, PROCESSING_STATUS
, ERROR_CODE
, ERROR_EXPLANATION
, REFERENCE_SOURCE_ID
, REFERENCE_SOURCE_DATE
, RETURN_BY_DATE
, SOURCE_TXN_LINE_DETAIL_ID
, INV_MTL_TRANSACTION_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, MIGRATED_FLAG
, INSTALL_LOCATION_TYPE_CODE
, INSTALL_LOCATION_ID
, CONFIG_INST_HDR_ID
, CONFIG_INST_REV_NUM
, CONFIG_INST_ITEM_ID
, CONFIG_INST_BASELINE_REV_NUM
, TARGET_COMMITMENT_DATE
, INSTANCE_DESCRIPTION
, REFERENCE_SOURCE_LINE_ID
, INSTANCE_STATUS_ID
, CASCADE_OWNER_FLAG
, PARENT_INSTANCE_ID
, ASSC_TXN_LINE_DETAIL_ID
, OVERRIDING_CSI_TXN_ID
FROM CSI.CSI_T_TXN_LINE_DETAILS;
CSI.CSI_T_TXN_LINE_DETAILS does not reference any database object
CSI.CSI_T_TXN_LINE_DETAILS is referenced by following:
APPS
CSI_T_TXN_LINE_DETAILS
|
|
|
|