View: PN_VAR_BKPTS_HEAD_V

Product:	PN - Property Manager
Description:	Form view used to input breakpoint header information.
Implementation/DBA Data:	APPS.PN_VAR_BKPTS_HEAD_V

View Text

SELECT BKHEAD.ROWID ROW_ID
, BKHEAD.BKPT_HEADER_ID BKPT_HEADER_ID
, BKHEAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BKHEAD.LAST_UPDATED_BY LAST_UPDATED_BY
, BKHEAD.CREATION_DATE CREATION_DATE
, BKHEAD.CREATED_BY CREATED_BY
, BKHEAD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BKHEAD.LINE_ITEM_ID LINE_ITEM_ID
, BKHEAD.PERIOD_ID PERIOD_ID
, BKHEAD.BREAK_TYPE BREAK_TYPE
, BKHEAD.BASE_RENT_TYPE BASE_RENT_TYPE
, BKHEAD.NATURAL_BREAK_RATE NATURAL_BREAK_RATE
, BKHEAD.BASE_RENT BASE_RENT
, BKHEAD.BREAKPOINT_TYPE BREAKPOINT_TYPE
, BKHEAD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BKHEAD.ATTRIBUTE1 ATTRIBUTE1
, BKHEAD.ATTRIBUTE2 ATTRIBUTE2
, BKHEAD.ATTRIBUTE3 ATTRIBUTE3
, BKHEAD.ATTRIBUTE4 ATTRIBUTE4
, BKHEAD.ATTRIBUTE5 ATTRIBUTE5
, BKHEAD.ATTRIBUTE6 ATTRIBUTE6
, BKHEAD.ATTRIBUTE7 ATTRIBUTE7
, BKHEAD.ATTRIBUTE8 ATTRIBUTE8
, BKHEAD.ATTRIBUTE9 ATTRIBUTE9
, BKHEAD.ATTRIBUTE10 ATTRIBUTE10
, BKHEAD.ATTRIBUTE11 ATTRIBUTE11
, BKHEAD.ATTRIBUTE12 ATTRIBUTE12
, BKHEAD.ATTRIBUTE13 ATTRIBUTE13
, BKHEAD.ATTRIBUTE14 ATTRIBUTE14
, BKHEAD.ATTRIBUTE15 ATTRIBUTE15
, BKHEAD.ORG_ID ORG_ID
FROM PN_VAR_PERIODS_ALL PER
, PN_VAR_LINES_ALL LINES
, PN_VAR_BKPTS_HEAD BKHEAD
WHERE PER.PERIOD_ID = BKHEAD.PERIOD_ID
AND LINES.LINE_ITEM_ID = BKHEAD.LINE_ITEM_ID

Columns