FND Design Data [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: ViewAPPS.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