VIEW: APPS.CSI_LINE_INST_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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