[Home] [Help]
View: CSI_T_TXN_LINE_DETAILS_V
Product: | CSI - Install Base |
Description: | View on top of Transaction Line Details CSI_T_TXN_LINE_DETAILS |
Implementation/DBA Data: |
APPS.CSI_T_TXN_LINE_DETAILS_V
|
View Text
SELECT TXN_LINE_DETAIL_ID
, TRANSACTION_LINE_ID
, INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID
, INVENTORY_REVISION
, QUANTITY
, UNIT_OF_MEASURE
, LOCATION_TYPE_CODE
, LOCATION_ID
, INSTANCE_DESCRIPTION
, CONFIG_INST_HDR_ID
, CONFIG_INST_REV_NUM
, CONFIG_INST_ITEM_ID
, CONFIG_INST_BASELINE_REV_NUM
, TARGET_COMMITMENT_DATE
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, OBJECT_VERSION_NUMBER FROM CSI_T_TXN_LINE_DETAILS
Columns
Name |
TXN_LINE_DETAIL_ID |
TRANSACTION_LINE_ID |
INVENTORY_ITEM_ID |
INV_ORGANIZATION_ID |
INVENTORY_REVISION |
QUANTITY |
UNIT_OF_MEASURE |
LOCATION_TYPE_CODE |
LOCATION_ID |
INSTANCE_DESCRIPTION |
CONFIG_INST_HDR_ID |
CONFIG_INST_REV_NUM |
CONFIG_INST_ITEM_ID |
CONFIG_INST_BASELINE_REV_NUM |
TARGET_COMMITMENT_DATE |
ACTIVE_START_DATE |
ACTIVE_END_DATE |
OBJECT_VERSION_NUMBER |