View: PN_VAR_LINES_DATES_V

Product:	PN - Property Manager
Description:	Form view for viewing variable rent line item details.
Implementation/DBA Data:	APPS.PN_VAR_LINES_DATES_V

View Text

SELECT PER.START_DATE
, PER.END_DATE
, PER.PERIOD_NUM
, LOOK.MEANING
, LOOK1.MEANING
, VARENT_DATES.INVG_FREQ_CODE
, VARENT_DATES.RECON_FREQ_CODE
, VARENT_DATES.REPTG_FREQ_CODE
, VARENT_DATES.AUDIT_FREQ_CODE
, VARENT.UOM_CODE
, VARENT.RENT_NUM
, LINES.LINE_ITEM_NUM
, LINES.SALES_TYPE_CODE
, LINES.ITEM_CATEGORY_CODE
, LINES.ROWID
, LINES.LINE_ITEM_ID
, LINES.PERIOD_ID
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
, LINES.CREATION_DATE
, LINES.CREATED_BY
, LINES.LAST_UPDATE_LOGIN
, VARENT.ORG_ID
FROM FND_LOOKUPS LOOK
, FND_LOOKUPS LOOK1
, PN_VAR_PERIODS_ALL PER
, PN_VAR_LINES_ALL LINES
, PN_VAR_RENT_DATES_ALL VARENT_DATES
, PN_VAR_RENTS VARENT
WHERE LINES.PERIOD_ID = PER.PERIOD_ID
AND PER.VAR_RENT_ID = VARENT.VAR_RENT_ID
AND VARENT.VAR_RENT_ID = VARENT_DATES.VAR_RENT_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

Columns