[Home] [Help]
View: CAC_SR_PERIOD_DTL_TYPES_VL
Product: | JTF - CRM Foundation |
Description: | This view contains describing attributes for a period detail type. |
Implementation/DBA Data: |
APPS.CAC_SR_PERIOD_DTL_TYPES_VL
|
View Text
SELECT CSPDTB.ROWID ROW_ID
, CSPDTB.PERIOD_DTL_TYPE_ID
, CSPDTB.DISPLAY_COLOR
, CSPDTTL.PERIOD_DTL_TYPE_NAME
, CSPDTTL.PERIOD_DTL_TYPE_DESC
, CSPDTB.CREATED_BY
, CSPDTB.CREATION_DATE
, CSPDTB.LAST_UPDATED_BY
, CSPDTB.LAST_UPDATE_DATE
, CSPDTB.LAST_UPDATE_LOGIN
FROM CAC_SR_PERIOD_DTL_TYPES_B CSPDTB
, CAC_SR_PERIOD_DTL_TYPES_TL CSPDTTL
WHERE CSPDTTL.PERIOD_DTL_TYPE_ID = CSPDTB.PERIOD_DTL_TYPE_ID
AND CSPDTTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PERIOD_DTL_TYPE_ID |
DISPLAY_COLOR |
PERIOD_DTL_TYPE_NAME |
PERIOD_DTL_TYPE_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |