VIEW: APPS.PN_VAR_LINES_V

Source

View Text - Preformatted

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 ,lines.LINE_TEMPLATE_ID line_template_id ,lines.AGREEMENT_TEMPLATE_ID agreement_template_id ,templ.AGREEMENT_TEMPLATE agreement_template ,lines.LINE_DEFAULT_ID line_default_id ,lines.VAR_RENT_ID var_rent_id ,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-nvl(vsumm.first_yr_rent,0)+ nvl(vsumm.trueup_var_rent,0)) actual_rent, sum(vsumm.FOR_VAR_RENT) forecasted_rent, vsumm.period_id,vsumm.line_item_id FROM PN_VAR_RENT_SUMM_ALL 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_lines lines, pn_var_templates_all templ WHERE 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 and templ.agreement_template_id(+) = lines.agreement_template_id

View Text - HTML Formatted

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
, LINES.LINE_TEMPLATE_ID LINE_TEMPLATE_ID
, LINES.AGREEMENT_TEMPLATE_ID AGREEMENT_TEMPLATE_ID
, TEMPL.AGREEMENT_TEMPLATE AGREEMENT_TEMPLATE
, LINES.LINE_DEFAULT_ID LINE_DEFAULT_ID
, LINES.VAR_RENT_ID VAR_RENT_ID
, 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-NVL(VSUMM.FIRST_YR_RENT
, 0)+ NVL(VSUMM.TRUEUP_VAR_RENT
, 0)) ACTUAL_RENT
, SUM(VSUMM.FOR_VAR_RENT) FORECASTED_RENT
, VSUMM.PERIOD_ID
, VSUMM.LINE_ITEM_ID
FROM PN_VAR_RENT_SUMM_ALL 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_LINES LINES
, PN_VAR_TEMPLATES_ALL TEMPL
WHERE 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
AND TEMPL.AGREEMENT_TEMPLATE_ID(+) = LINES.AGREEMENT_TEMPLATE_ID