DBA Data[Home] [Help]

VIEW: APPS.CSM_CSI_TXN_TYPES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.TRANSACTION_TYPE_ID , B.SOURCE_APPLICATION_ID , B.SOURCE_TRANSACTION_TYPE , B.SOURCE_TXN_TYPE_NAME , B.DESCRIPTION , B.SOURCE_OBJECT_CODE , B.IN_OUT_FLAG FROM CSI_TXN_TYPES B , CSM_CSI_TXN_TYPES_ACC ACC WHERE B.TRANSACTION_TYPE_ID = ACC.TRANSACTION_TYPE_ID
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.TRANSACTION_TYPE_ID
, B.SOURCE_APPLICATION_ID
, B.SOURCE_TRANSACTION_TYPE
, B.SOURCE_TXN_TYPE_NAME
, B.DESCRIPTION
, B.SOURCE_OBJECT_CODE
, B.IN_OUT_FLAG
FROM CSI_TXN_TYPES B
, CSM_CSI_TXN_TYPES_ACC ACC
WHERE B.TRANSACTION_TYPE_ID = ACC.TRANSACTION_TYPE_ID