VIEW: APPS.CSI_TXN_SUB_TYPES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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