Product: | PN - Property Manager |
---|---|
Description: | Form view used to input volume history related information. |
Implementation/DBA Data: | APPS.PN_VAR_VOL_HIST_V |
SELECT HIST.ROWID ROW_ID
, HIST.VOL_HIST_ID VOL_HIST_ID
, HIST.VOL_HIST_NUM VOL_HIST_NUM
, HIST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HIST.LAST_UPDATED_BY LAST_UPDATED_BY
, HIST.CREATION_DATE CREATION_DATE
, HIST.CREATED_BY CREATED_BY
, HIST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HIST.LINE_ITEM_ID LINE_ITEM_ID
, HIST.PERIOD_ID PERIOD_ID
, HIST.START_DATE START_DATE
, HIST.END_DATE END_DATE
, HIST.GRP_DATE_ID GRP_DATE_ID
, HIST.GROUP_DATE GROUP_DATE
, HIST.REPORTING_DATE REPORTING_DATE
, HIST.DUE_DATE DUE_DATE
, HIST.INVOICING_DATE INVOICING_DATE
, HIST.ACTUAL_GL_ACCOUNT_ID ACTUAL_GL_ACCOUNT_ID
, HIST.ACTUAL_AMOUNT ACTUAL_AMOUNT
, HIST.VOL_HIST_STATUS_CODE VOL_HIST_STATUS_CODE
, HIST.REPORT_TYPE_CODE REPORT_TYPE_CODE
, HIST.CERTIFIED_BY ABSTRACTED_BY_USER_ID
, USER1.USER_NAME USER_ABSTRACTED
, HIST.ACTUAL_EXP_CODE ACTUAL_EXP_CODE
, HIST.FOR_GL_ACCOUNT_ID FOR_GL_ACCOUNT_ID
, HIST.FORECASTED_AMOUNT FORECASTED_AMOUNT
, HIST.FORECASTED_EXP_CODE FORECASTED_EXP_CODE
, (HIST.ACTUAL_AMOUNT- HIST.FORECASTED_AMOUNT) VARIANCE_AMOUNT
, HIST.VARIANCE_EXP_CODE VARIANCE_EXP_CODE
, HIST.COMMENTS COMMENTS
, HIST.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, HIST.ATTRIBUTE1 ATTRIBUTE1
, HIST.ATTRIBUTE2 ATTRIBUTE2
, HIST.ATTRIBUTE3 ATTRIBUTE3
, HIST.ATTRIBUTE4 ATTRIBUTE4
, HIST.ATTRIBUTE5 ATTRIBUTE5
, HIST.ATTRIBUTE6 ATTRIBUTE6
, HIST.ATTRIBUTE7 ATTRIBUTE7
, HIST.ATTRIBUTE8 ATTRIBUTE8
, HIST.ATTRIBUTE9 ATTRIBUTE9
, HIST.ATTRIBUTE10 ATTRIBUTE10
, HIST.ATTRIBUTE11 ATTRIBUTE11
, HIST.ATTRIBUTE12 ATTRIBUTE12
, HIST.ATTRIBUTE13 ATTRIBUTE13
, HIST.ATTRIBUTE14 ATTRIBUTE14
, HIST.ATTRIBUTE15 ATTRIBUTE15
, HIST.ORG_ID ORG_ID
FROM PN_VAR_PERIODS_ALL PER
, PN_VAR_LINES_ALL LINES
, FND_USER USER1
, PN_VAR_VOL_HIST HIST
WHERE PER.PERIOD_ID = HIST.PERIOD_ID
AND LINES.LINE_ITEM_ID = HIST.LINE_ITEM_ID
AND USER1.USER_ID(+) = HIST.CERTIFIED_BY