VIEW: CSI.CSI_T_TXN_LINE_DETAILS#

Source

View Text - Preformatted

select TXN_LINE_DETAIL_ID TXN_LINE_DETAIL_ID, TRANSACTION_LINE_ID TRANSACTION_LINE_ID, INSTANCE_EXISTS_FLAG INSTANCE_EXISTS_FLAG, SOURCE_TRANSACTION_FLAG SOURCE_TRANSACTION_FLAG, INSTANCE_ID INSTANCE_ID, CSI_SYSTEM_ID CSI_SYSTEM_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, INVENTORY_REVISION INVENTORY_REVISION, INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE, ITEM_CONDITION_ID ITEM_CONDITION_ID, QUANTITY QUANTITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, QTY_REMAINING QTY_REMAINING, SERIAL_NUMBER SERIAL_NUMBER, LOT_NUMBER LOT_NUMBER, MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG, LOCATION_TYPE_CODE LOCATION_TYPE_CODE, LOCATION_ID LOCATION_ID, INSTALLATION_DATE INSTALLATION_DATE, IN_SERVICE_DATE IN_SERVICE_DATE, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, VERSION_LABEL VERSION_LABEL, TRANSACTION_SYSTEM_ID TRANSACTION_SYSTEM_ID, SELLABLE_FLAG SELLABLE_FLAG, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, PRESERVE_DETAIL_FLAG PRESERVE_DETAIL_FLAG, CHANGED_INSTANCE_ID CHANGED_INSTANCE_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, CONTEXT CONTEXT, SUB_TYPE_ID SUB_TYPE_ID, CSI_TRANSACTION_ID CSI_TRANSACTION_ID, PROCESSING_STATUS PROCESSING_STATUS, ERROR_CODE ERROR_CODE, ERROR_EXPLANATION ERROR_EXPLANATION, REFERENCE_SOURCE_ID REFERENCE_SOURCE_ID, REFERENCE_SOURCE_DATE REFERENCE_SOURCE_DATE, RETURN_BY_DATE RETURN_BY_DATE, SOURCE_TXN_LINE_DETAIL_ID SOURCE_TXN_LINE_DETAIL_ID, INV_MTL_TRANSACTION_ID INV_MTL_TRANSACTION_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MIGRATED_FLAG MIGRATED_FLAG, INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE, INSTALL_LOCATION_ID INSTALL_LOCATION_ID, CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID, CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM, CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID, CONFIG_INST_BASELINE_REV_NUM CONFIG_INST_BASELINE_REV_NUM, TARGET_COMMITMENT_DATE TARGET_COMMITMENT_DATE, INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION, REFERENCE_SOURCE_LINE_ID REFERENCE_SOURCE_LINE_ID, INSTANCE_STATUS_ID INSTANCE_STATUS_ID, CASCADE_OWNER_FLAG CASCADE_OWNER_FLAG, PARENT_INSTANCE_ID PARENT_INSTANCE_ID, ASSC_TXN_LINE_DETAIL_ID ASSC_TXN_LINE_DETAIL_ID, OVERRIDING_CSI_TXN_ID OVERRIDING_CSI_TXN_ID from "CSI"."CSI_T_TXN_LINE_DETAILS"

View Text - HTML Formatted

SELECT TXN_LINE_DETAIL_ID TXN_LINE_DETAIL_ID
, TRANSACTION_LINE_ID TRANSACTION_LINE_ID
, INSTANCE_EXISTS_FLAG INSTANCE_EXISTS_FLAG
, SOURCE_TRANSACTION_FLAG SOURCE_TRANSACTION_FLAG
, INSTANCE_ID INSTANCE_ID
, CSI_SYSTEM_ID CSI_SYSTEM_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, INVENTORY_REVISION INVENTORY_REVISION
, INSTANCE_TYPE_CODE INSTANCE_TYPE_CODE
, ITEM_CONDITION_ID ITEM_CONDITION_ID
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, QTY_REMAINING QTY_REMAINING
, SERIAL_NUMBER SERIAL_NUMBER
, LOT_NUMBER LOT_NUMBER
, MFG_SERIAL_NUMBER_FLAG MFG_SERIAL_NUMBER_FLAG
, LOCATION_TYPE_CODE LOCATION_TYPE_CODE
, LOCATION_ID LOCATION_ID
, INSTALLATION_DATE INSTALLATION_DATE
, IN_SERVICE_DATE IN_SERVICE_DATE
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, VERSION_LABEL VERSION_LABEL
, TRANSACTION_SYSTEM_ID TRANSACTION_SYSTEM_ID
, SELLABLE_FLAG SELLABLE_FLAG
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, PRESERVE_DETAIL_FLAG PRESERVE_DETAIL_FLAG
, CHANGED_INSTANCE_ID CHANGED_INSTANCE_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CONTEXT CONTEXT
, SUB_TYPE_ID SUB_TYPE_ID
, CSI_TRANSACTION_ID CSI_TRANSACTION_ID
, PROCESSING_STATUS PROCESSING_STATUS
, ERROR_CODE ERROR_CODE
, ERROR_EXPLANATION ERROR_EXPLANATION
, REFERENCE_SOURCE_ID REFERENCE_SOURCE_ID
, REFERENCE_SOURCE_DATE REFERENCE_SOURCE_DATE
, RETURN_BY_DATE RETURN_BY_DATE
, SOURCE_TXN_LINE_DETAIL_ID SOURCE_TXN_LINE_DETAIL_ID
, INV_MTL_TRANSACTION_ID INV_MTL_TRANSACTION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MIGRATED_FLAG MIGRATED_FLAG
, INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CONFIG_INST_HDR_ID CONFIG_INST_HDR_ID
, CONFIG_INST_REV_NUM CONFIG_INST_REV_NUM
, CONFIG_INST_ITEM_ID CONFIG_INST_ITEM_ID
, CONFIG_INST_BASELINE_REV_NUM CONFIG_INST_BASELINE_REV_NUM
, TARGET_COMMITMENT_DATE TARGET_COMMITMENT_DATE
, INSTANCE_DESCRIPTION INSTANCE_DESCRIPTION
, REFERENCE_SOURCE_LINE_ID REFERENCE_SOURCE_LINE_ID
, INSTANCE_STATUS_ID INSTANCE_STATUS_ID
, CASCADE_OWNER_FLAG CASCADE_OWNER_FLAG
, PARENT_INSTANCE_ID PARENT_INSTANCE_ID
, ASSC_TXN_LINE_DETAIL_ID ASSC_TXN_LINE_DETAIL_ID
, OVERRIDING_CSI_TXN_ID OVERRIDING_CSI_TXN_ID
FROM "CSI"."CSI_T_TXN_LINE_DETAILS"