VIEW: APPS.PQH_WORKSHEET_PERIODS_V

Source

View Text - Preformatted

SELECT WPR.WORKSHEET_DETAIL_ID,WPR.WORKSHEET_PERIOD_ID,WPR.START_TIME_PERIOD_ID,WPR.END_TIME_PERIOD_ID,PTPS.START_DATE,PTPE.END_DATE,WPR.BUDGET_UNIT1_VALUE,WPR.BUDGET_UNIT2_VALUE,WPR.BUDGET_UNIT3_VALUE,WPR.BUDGET_UNIT1_PERCENT,WPR.BUDGET_UNIT2_PERCENT,WPR.BUDGET_UNIT3_PERCENT,WPR.BUDGET_UNIT1_VALUE_TYPE_CD,WPR.BUDGET_UNIT2_VALUE_TYPE_CD,WPR.BUDGET_UNIT3_VALUE_TYPE_CD,WPR.BUDGET_UNIT1_AVAILABLE,WPR.BUDGET_UNIT2_AVAILABLE,WPR.BUDGET_UNIT3_AVAILABLE,WPR.OBJECT_VERSION_NUMBER,WPR.LAST_UPDATED_BY,WPR.LAST_UPDATE_DATE,WPR.LAST_UPDATE_LOGIN,WPR.CREATED_BY,WPR.CREATION_DATE FROM PQH_WORKSHEET_PERIODS WPR,PER_TIME_PERIODS PTPS,PER_TIME_PERIODS PTPE WHERE ptps.time_period_id = WPR.start_time_period_id AND ptpe.time_period_id = WPR.end_time_period_id

View Text - HTML Formatted

SELECT WPR.WORKSHEET_DETAIL_ID
, WPR.WORKSHEET_PERIOD_ID
, WPR.START_TIME_PERIOD_ID
, WPR.END_TIME_PERIOD_ID
, PTPS.START_DATE
, PTPE.END_DATE
, WPR.BUDGET_UNIT1_VALUE
, WPR.BUDGET_UNIT2_VALUE
, WPR.BUDGET_UNIT3_VALUE
, WPR.BUDGET_UNIT1_PERCENT
, WPR.BUDGET_UNIT2_PERCENT
, WPR.BUDGET_UNIT3_PERCENT
, WPR.BUDGET_UNIT1_VALUE_TYPE_CD
, WPR.BUDGET_UNIT2_VALUE_TYPE_CD
, WPR.BUDGET_UNIT3_VALUE_TYPE_CD
, WPR.BUDGET_UNIT1_AVAILABLE
, WPR.BUDGET_UNIT2_AVAILABLE
, WPR.BUDGET_UNIT3_AVAILABLE
, WPR.OBJECT_VERSION_NUMBER
, WPR.LAST_UPDATED_BY
, WPR.LAST_UPDATE_DATE
, WPR.LAST_UPDATE_LOGIN
, WPR.CREATED_BY
, WPR.CREATION_DATE
FROM PQH_WORKSHEET_PERIODS WPR
, PER_TIME_PERIODS PTPS
, PER_TIME_PERIODS PTPE
WHERE PTPS.TIME_PERIOD_ID = WPR.START_TIME_PERIOD_ID
AND PTPE.TIME_PERIOD_ID = WPR.END_TIME_PERIOD_ID