View: CSI_LINE_INST_DETAILS_V

Product:	CSI - Install Base
Description:	Backward Compatible : Installation details ( View for table CS_LINE_INST_DETAILS)
Implementation/DBA Data:	APPS.CSI_LINE_INST_DETAILS_V

View Text

SELECT CTTLD.TXN_LINE_DETAIL_ID
, DECODE(CTTL.SOURCE_TRANSACTION_TABLE
, 'OE_ORDER_LINES_ALL'
, CTTL.SOURCE_TRANSACTION_ID
, NULL)
, DECODE(CTTL.SOURCE_TRANSACTION_TABLE
, 'WSH_DELIVERY_DETAILS'
, CTTL.SOURCE_TRANSACTION_ID
, NULL)
, NULL
, CT.TRANSACTION_TYPE_ID
, CTTLD.CSI_SYSTEM_ID
, CTTLD.INSTANCE_ID
, CTTLD.INSTANCE_TYPE_CODE
, CTTLD.QUANTITY
, CTPD.PARTY_SOURCE_ID
, NULL
, NULL
, NULL
, NULL
, CTTLD.INSTALLATION_DATE
, CTTLD.CREATED_BY
, CTTLD.CREATION_DATE
, CTTLD.LAST_UPDATED_BY
, CTTLD.LAST_UPDATE_DATE
, CTTLD.LAST_UPDATE_LOGIN
, CTTLD.CONTEXT
, CTTLD.ATTRIBUTE1
, CTTLD.ATTRIBUTE2
, CTTLD.ATTRIBUTE3
, CTTLD.ATTRIBUTE4
, CTTLD.ATTRIBUTE5
, CTTLD.ATTRIBUTE6
, CTTLD.ATTRIBUTE7
, CTTLD.ATTRIBUTE8
, CTTLD.ATTRIBUTE9
, CTTLD.ATTRIBUTE10
, CTTLD.ATTRIBUTE11
, CTTLD.ATTRIBUTE12
, CTTLD.ATTRIBUTE13
, CTTLD.ATTRIBUTE14
, CTTLD.ATTRIBUTE15
, CTTLD.OBJECT_VERSION_NUMBER
, CTTLD.ACTIVE_START_DATE
, CTTLD.ACTIVE_END_DATE
, NULL
FROM CSI_T_TXN_LINE_DETAILS CTTLD
, CSI_T_TRANSACTION_LINES CTTL
, CSI_T_PARTY_DETAILS CTPD
, CSI_TRANSACTIONS CT
WHERE CTTL.TRANSACTION_LINE_ID = CTTLD.TRANSACTION_LINE_ID(+)
AND CTPD.TXN_LINE_DETAIL_ID = CTTLD.TXN_LINE_DETAIL_ID
AND CTTLD.CSI_TRANSACTION_ID = CT.TRANSACTION_ID

Columns