View: CSI_TXN_SUB_TYPES

Product:	CSI - Install Base
Description:	Source transaction and Install Base transaction Types association.
Implementation/DBA Data:	APPS.CSI_TXN_SUB_TYPES

View Text

SELECT REL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, IBT.SUB_TYPE_ID SUB_TYPE_ID
, IBT.CS_TRANSACTION_TYPE_ID CS_TRANSACTION_TYPE_ID
, IBT.IB_TXN_TYPE_CODE IB_TXN_TYPE_CODE
, DECODE( NVL(IBT.CS_TRANSACTION_TYPE_ID
, -1)
, -1
, CSL.MEANING
, CSTT.NAME) NAME
, DECODE( NVL(IBT.CS_TRANSACTION_TYPE_ID
, -1)
, -1
, CSL.DESCRIPTION
, CSTT.DESCRIPTION) DESCRIPTION
, IBT.SRC_REFERENCE_REQD SRC_REFERENCE_REQD
, IBT.SRC_CHANGE_OWNER SRC_CHANGE_OWNER
, IBT.SRC_CHANGE_OWNER_TO_CODE SRC_CHANGE_OWNER_TO_CODE
, IBT.SRC_STATUS_ID SRC_STATUS_ID
, IBT.SRC_RETURN_REQD SRC_RETURN_REQD
, IBT.SRC_REVISION_REQD SRC_REVISION_REQD
, IBT.NON_SRC_REFERENCE_REQD NON_SRC_REFERENCE_REQD
, IBT.NON_SRC_CHANGE_OWNER NON_SRC_CHANGE_OWNER
, IBT.NON_SRC_CHANGE_OWNER_TO_CODE NON_SRC_CHANGE_OWNER_TO_CODE
, IBT.NON_SRC_STATUS_ID NON_SRC_STATUS_ID
, IBT.NON_SRC_RETURN_REQD NON_SRC_RETURN_REQD
, IBT.PARENT_REFERENCE_REQD PARENT_REFERENCE_REQD
, IBT.PARENT_STATUS_ID PARENT_STATUS_ID
, IBT.PARENT_REVISION_REQD PARENT_REVISION_REQD
, IBT.SEEDED_FLAG SEEDED_FLAG
, IBT.FREEZE_FLAG FREEZE_FLAG
, IBT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REL.DEFAULT_FLAG DEFAULT_FLAG
, REL.UPDATE_IB_FLAG UPDATE_IB_FLAG
FROM CSI_IB_TXN_TYPES IBT
, CSI_SOURCE_IB_TYPES REL
, CSI_LOOKUPS CSL
, CS_TRANSACTION_TYPES CSTT
WHERE IBT.SUB_TYPE_ID = REL.SUB_TYPE_ID AND CSL.LOOKUP_CODE(+) = IBT.IB_TXN_TYPE_CODE AND CSL.LOOKUP_TYPE(+) = 'CSI_IB_TXN_TYPE_CODE' AND CSTT.TRANSACTION_TYPE_ID(+) = IBT.CS_TRANSACTION_TYPE_ID

Columns