View: PN_VAR_DEDUCTIONS_V

Product:	PN - Property Manager
Description:	Form view used to input deductions related information.
Implementation/DBA Data:	APPS.PN_VAR_DEDUCTIONS_V

View Text

SELECT DED.ROWID ROW_ID
, DED.DEDUCTION_ID DEDUCTION_ID
, DED.DEDUCTION_NUM DEDUCTION_NUM
, DED.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DED.LAST_UPDATED_BY LAST_UPDATED_BY
, DED.CREATION_DATE CREATION_DATE
, DED.CREATED_BY CREATED_BY
, DED.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DED.LINE_ITEM_ID LINE_ITEM_ID
, DED.PERIOD_ID PERIOD_ID
, DED.START_DATE START_DATE
, DED.END_DATE END_DATE
, DED.GROUP_DATE GROUP_DATE
, DED.INVOICING_DATE INVOICING_DATE
, DED.GRP_DATE_ID GRP_DATE_ID
, DED.GL_ACCOUNT_ID GL_ACCOUNT_ID
, DED.DEDUCTION_TYPE_CODE DEDUCTION_TYPE_CODE
, FND.MEANING DEDUCTION_TYPE
, DED.DEDUCTION_AMOUNT DEDUCTION_AMOUNT
, (SUM(DED.DEDUCTION_AMOUNT) OVER (PARTITION BY DED.LINE_ITEM_ID ORDER BY DED.DEDUCTION_NUM)) AS DEDUCTION_CUM_AMT
, DED.EXPORTED_CODE EXPORTED_CODE
, DED.COMMENTS COMMENTS
, DED.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DED.ATTRIBUTE1 ATTRIBUTE1
, DED.ATTRIBUTE2 ATTRIBUTE2
, DED.ATTRIBUTE3 ATTRIBUTE3
, DED.ATTRIBUTE4 ATTRIBUTE4
, DED.ATTRIBUTE5 ATTRIBUTE5
, DED.ATTRIBUTE6 ATTRIBUTE6
, DED.ATTRIBUTE7 ATTRIBUTE7
, DED.ATTRIBUTE8 ATTRIBUTE8
, DED.ATTRIBUTE9 ATTRIBUTE9
, DED.ATTRIBUTE10 ATTRIBUTE10
, DED.ATTRIBUTE11 ATTRIBUTE11
, DED.ATTRIBUTE12 ATTRIBUTE12
, DED.ATTRIBUTE13 ATTRIBUTE13
, DED.ATTRIBUTE14 ATTRIBUTE14
, DED.ATTRIBUTE15 ATTRIBUTE15
, DED.ORG_ID ORG_ID
FROM FND_LOOKUPS FND
, PN_VAR_PERIODS_ALL PER
, PN_VAR_LINES_ALL LINES
, PN_VAR_DEDUCTIONS DED
WHERE PER.PERIOD_ID = DED.PERIOD_ID
AND LINES.LINE_ITEM_ID = DED.LINE_ITEM_ID
AND FND.LOOKUP_TYPE(+) = 'PN_DEDUCTION_TYPE'
AND FND.LOOKUP_CODE(+) = DED.DEDUCTION_TYPE_CODE

Columns