View: PN_VAR_LINES_V

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

View Text

SELECT LINES.ROWID ROW_ID
, LINES.LINE_ITEM_ID LINE_ITEM_ID
, LINES.LINE_ITEM_NUM LINE_ITEM_NUM
, LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY LAST_UPDATED_BY
, LINES.CREATION_DATE CREATION_DATE
, LINES.CREATED_BY CREATED_BY
, LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINES.PERIOD_ID PERIOD_ID
, LINES.SALES_TYPE_CODE SALES_TYPE_CODE
, LOOK.MEANING SALES_CHANNEL
, LINES.ITEM_CATEGORY_CODE ITEM_CATEGORY_CODE
, LOOK1.MEANING ITEM_CATEGORY
, LINES.COMMENTS COMMENTS
, SUMM.ACTUAL_RENT ACTUAL_RENT
, SUMM.FORECASTED_RENT FORECASTED_RENT
, LINES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LINES.ATTRIBUTE1 ATTRIBUTE1
, LINES.ATTRIBUTE2 ATTRIBUTE2
, LINES.ATTRIBUTE3 ATTRIBUTE3
, LINES.ATTRIBUTE4 ATTRIBUTE4
, LINES.ATTRIBUTE5 ATTRIBUTE5
, LINES.ATTRIBUTE6 ATTRIBUTE6
, LINES.ATTRIBUTE7 ATTRIBUTE7
, LINES.ATTRIBUTE8 ATTRIBUTE8
, LINES.ATTRIBUTE9 ATTRIBUTE9
, LINES.ATTRIBUTE10 ATTRIBUTE10
, LINES.ATTRIBUTE11 ATTRIBUTE11
, LINES.ATTRIBUTE12 ATTRIBUTE12
, LINES.ATTRIBUTE13 ATTRIBUTE13
, LINES.ATTRIBUTE14 ATTRIBUTE14
, LINES.ATTRIBUTE15 ATTRIBUTE15
, LINES.ORG_ID ORG_ID
FROM (SELECT SUM(VSUMM.ACT_VAR_RENT) ACTUAL_RENT
, SUM(VSUMM.FOR_VAR_RENT) FORECASTED_RENT
, VSUMM.PERIOD_ID
, VSUMM.LINE_ITEM_ID
FROM PN_VAR_RENT_SUMM VSUMM
, PN_VAR_LINES LINES
WHERE VSUMM.PERIOD_ID = LINES.PERIOD_ID
AND VSUMM.LINE_ITEM_ID= LINES.LINE_ITEM_ID GROUP BY VSUMM.LINE_ITEM_ID
, VSUMM.PERIOD_ID) SUMM
, FND_LOOKUPS LOOK
, FND_LOOKUPS LOOK1
, PN_VAR_PERIODS PER
, PN_VAR_LINES LINES
WHERE LINES.PERIOD_ID = PER.PERIOD_ID
AND LOOK.LOOKUP_TYPE(+) = 'PN_SALES_CHANNEL'
AND LOOK.LOOKUP_CODE(+) = LINES.SALES_TYPE_CODE
AND LOOK1.LOOKUP_TYPE(+)= 'PN_ITEM_CATEGORY'
AND LOOK1.LOOKUP_CODE(+)= LINES.ITEM_CATEGORY_CODE
AND SUMM.LINE_ITEM_ID(+)= LINES.LINE_ITEM_ID
AND SUMM.PERIOD_ID(+) = LINES.PERIOD_ID

Columns