View: CSI_SRC_TXN_SUB_TYPES

Product:	CSI - Install Base
Description:	Transaction Sources and the applicable Installed Base transactions.
Implementation/DBA Data:	APPS.CSI_SRC_TXN_SUB_TYPES

View Text

SELECT CTT.TRANSACTION_TYPE_ID
, CTT.SOURCE_APPLICATION_ID
, CTT.SOURCE_TRANSACTION_TYPE
, CTT.SOURCE_TXN_TYPE_NAME
, CTT.DESCRIPTION
, CTT.SOURCE_OBJECT_CODE
, CTT.IN_OUT_FLAG
, CTT.CREATED_BY
, CTT.CREATION_DATE
, CTT.LAST_UPDATED_BY
, CTT.LAST_UPDATE_DATE
, CTT.LAST_UPDATE_LOGIN
, CTT.OBJECT_VERSION_NUMBER
, CSIT.SUB_TYPE_ID
, CSIT.DEFAULT_FLAG
, CSIT.UPDATE_IB_FLAG
FROM CSI_TXN_TYPES CTT
, CSI_SOURCE_IB_TYPES CSIT
WHERE CTT.TRANSACTION_TYPE_ID = CSIT.TRANSACTION_TYPE_ID

Columns