eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CAC_SR_PERIODS_VL

Product:	JTF - CRM Foundation
Description:	This view contains describing attributes for a period.
Implementation/DBA Data:	APPS.CAC_SR_PERIODS_VL

View Text

SELECT CSPB.ROWID ROW_ID
, CSPB.PERIOD_ID
, CSPB.OBJECT_VERSION_NUMBER
, CSPB.PERIOD_CATEGORY_ID
, CSPB.START_DATE_ACTIVE
, CSPB.END_DATE_ACTIVE
, CSPB.SHOW_IN_LOV
, CSPB.WEEK_DAY_NUM
, CSPB.START_TIME_MS
, CSPB.END_TIME_MS
, CSPB.DURATION
, CSPB.DURATION_UOM
, CSPB.SHORT_CODE
, CSPB.HAS_DETAILS
, CSPTL.PERIOD_NAME
, CSPTL.PERIOD_DESC
, CSPB.CREATED_BY
, CSPB.CREATION_DATE
, CSPB.LAST_UPDATED_BY
, CSPB.LAST_UPDATE_DATE
, CSPB.LAST_UPDATE_LOGIN
FROM CAC_SR_PERIODS_B CSPB
, CAC_SR_PERIODS_TL CSPTL
WHERE CSPTL.PERIOD_ID=CSPB.PERIOD_ID
AND CSPTL.LANGUAGE=USERENV('LANG')

Columns

Name
ROW_ID
PERIOD_ID
OBJECT_VERSION_NUMBER
PERIOD_CATEGORY_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
SHOW_IN_LOV
WEEK_DAY_NUM
START_TIME_MS
END_TIME_MS
DURATION
DURATION_UOM
SHORT_CODE
HAS_DETAILS
PERIOD_NAME
PERIOD_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN