View: CS_TRANSACTION_TYPES_V

Product:	CS - Service
Description:	Transaction types
Implementation/DBA Data:	APPS.CS_TRANSACTION_TYPES_V

View Text

SELECT TT.ROWID ROW_ID
, TT.TRANSACTION_TYPE_ID
, TT.LAST_UPDATE_DATE
, TT.LAST_UPDATED_BY
, TT.CREATION_DATE
, TT.CREATED_BY
, TT.LAST_UPDATE_LOGIN
, TTL.NAME
, TT.SEEDED_FLAG
, TT.INSTALLED_STATUS_CODE
, TT.REVISION_FLAG
, TT.END_DATE_ACTIVE
, TT.START_DATE_ACTIVE
, TTL.DESCRIPTION
, TT.NEW_CP_STATUS_ID
, TT.NEW_CP_STATUS_CODE
, TT.NEW_CP_RETURN_REQUIRED
, TT.INSTALLED_CP_RETURN_REQUIRED
, TT.TRANSFER_SERVICE
, NULL NEW_CP_STATUS_NAME
, NULL NEW_CP_STATUS_DESC
, TT.INSTALLED_CP_STATUS_ID
, NULL CUSTOMER_PRODUCT_STATUS_NAME
, NULL CUSTOMER_PRODUCT_STATUS_DESC
, NULL INSTALLED_BASE
, TT.MOVE_COUNTERS_FLAG
, TT.NO_CHARGE_FLAG
, TT.DEPOT_REPAIR_FLAG
, TT.ATTRIBUTE1
, TT.ATTRIBUTE2
, TT.ATTRIBUTE3
, TT.ATTRIBUTE4
, TT.ATTRIBUTE5
, TT.ATTRIBUTE6
, TT.ATTRIBUTE7
, TT.ATTRIBUTE8
, TT.ATTRIBUTE9
, TT.ATTRIBUTE10
, TT.ATTRIBUTE11
, TT.ATTRIBUTE12
, TT.ATTRIBUTE13
, TT.ATTRIBUTE14
, TT.ATTRIBUTE15
, TT.CONTEXT
, TT.OBJECT_VERSION_NUMBER
, TT.LINE_ORDER_CATEGORY_CODE
, TT.INTERFACE_TO_OE_FLAG
FROM CS_TRANSACTION_TYPES_B TT
, CS_TRANSACTION_TYPES_TL TTL
WHERE TT.TRANSACTION_TYPE_ID = TTL.TRANSACTION_TYPE_ID
AND TTL.LANGUAGE = USERENV('LANG')

Columns