View: PN_OPTIONS_HISTORY_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_OPTIONS_HISTORY_V

View Text

SELECT OPT.ROWID ROW_ID
, OPT.OPTION_ID OPTION_ID
, OPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY LAST_UPDATED_BY
, OPT.CREATION_DATE CREATION_DATE
, OPT.CREATED_BY CREATED_BY
, OPT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OPT.LEASE_ID LEASE_ID
, OPT.LEASE_CHANGE_ID LEASE_CHANGE_ID
, OPT.OPTION_NUM OPTION_NUM
, OPT.OPTION_TYPE_CODE OPTION_TYPE_CODE
, OPT.START_DATE START_DATE
, OPT.EXPIRATION_DATE EXPIRATION_DATE
, (TRUNC(OPT.EXPIRATION_DATE) - TRUNC(OPT.START_DATE)+1) OPTION_TERM
, OPT.OPTION_SIZE OPTION_SIZE
, OPT.UOM_CODE UOM_CODE
, OPT.OPTION_STATUS_LOOKUP_CODE OPTION_STATUS_LOOKUP_CODE
, OPT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, OPT.ATTRIBUTE1 ATTRIBUTE1
, OPT.ATTRIBUTE2 ATTRIBUTE2
, OPT.ATTRIBUTE3 ATTRIBUTE3
, OPT.ATTRIBUTE4 ATTRIBUTE4
, OPT.ATTRIBUTE5 ATTRIBUTE5
, OPT.ATTRIBUTE6 ATTRIBUTE6
, OPT.ATTRIBUTE7 ATTRIBUTE7
, OPT.ATTRIBUTE8 ATTRIBUTE8
, OPT.ATTRIBUTE9 ATTRIBUTE9
, OPT.ATTRIBUTE10 ATTRIBUTE10
, OPT.ATTRIBUTE11 ATTRIBUTE11
, OPT.ATTRIBUTE12 ATTRIBUTE12
, OPT.ATTRIBUTE13 ATTRIBUTE13
, OPT.ATTRIBUTE14 ATTRIBUTE14
, OPT.ATTRIBUTE15 ATTRIBUTE15
, TLOOK.MEANING OPTION_TYPE
, OLOOK.MEANING OPTION_STATUS_TYPE
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, TO_NUMBER (NULL) OPTION_HISTORY_ID
, TO_NUMBER (NULL) NEW_LEASE_CHANGE_ID
, 'Y' CURRENT_FLAG
, OPT.OPTION_EXER_START_DATE OPTION_EXER_START_DATE
, OPT.OPTION_EXER_END_DATE OPTION_EXER_END_DATE
, OPT.OPTION_ACTION_DATE OPTION_ACTION_DATE
, OPT.OPTION_COST OPTION_COST
, OPT.OPTION_AREA_CHANGE OPTION_AREA_CHANGE
, OPT.OPTION_REFERENCE OPTION_REFERENCE
, OPT.OPTION_NOTICE_REQD OPTION_NOTICE_REQD
, OPT.OPTION_COMMENTS OPTION_COMMENTS
FROM MTL_UNITS_OF_MEASURE UOM
, FND_LOOKUPS TLOOK
, FND_LOOKUPS OLOOK
, PN_OPTIONS OPT
WHERE TLOOK.LOOKUP_TYPE = 'PN_LEASE_OPTION_TYPE'
AND TLOOK.LOOKUP_CODE = OPT.OPTION_TYPE_CODE
AND OLOOK.LOOKUP_TYPE = 'PN_OPTION_STATUS_TYPE'
AND OLOOK.LOOKUP_CODE = OPT.OPTION_STATUS_LOOKUP_CODE
AND UOM.UOM_CODE (+) = OPT.UOM_CODE UNION ALL SELECT OPT.ROWID ROW_ID
, OPT.OPTION_ID OPTION_ID
, OPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY LAST_UPDATED_BY
, OPT.CREATION_DATE CREATION_DATE
, OPT.CREATED_BY CREATED_BY
, OPT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OPT.LEASE_ID LEASE_ID
, OPT.LEASE_CHANGE_ID LEASE_CHANGE_ID
, OPT.OPTION_NUM OPTION_NUM
, OPT.OPTION_TYPE_CODE OPTION_TYPE_CODE
, OPT.START_DATE START_DATE
, OPT.EXPIRATION_DATE EXPIRATION_DATE
, (TRUNC(OPT.START_DATE) - TRUNC(OPT.EXPIRATION_DATE)) OPTION_TERM
, OPT.OPTION_SIZE OPTION_SIZE
, OPT.UOM_CODE UOM_CODE
, OPT.OPTION_STATUS_LOOKUP_CODE OPTION_STATUS_LOOKUP_CODE
, OPT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, OPT.ATTRIBUTE1 ATTRIBUTE1
, OPT.ATTRIBUTE2 ATTRIBUTE2
, OPT.ATTRIBUTE3 ATTRIBUTE3
, OPT.ATTRIBUTE4 ATTRIBUTE4
, OPT.ATTRIBUTE5 ATTRIBUTE5
, OPT.ATTRIBUTE6 ATTRIBUTE6
, OPT.ATTRIBUTE7 ATTRIBUTE7
, OPT.ATTRIBUTE8 ATTRIBUTE8
, OPT.ATTRIBUTE9 ATTRIBUTE9
, OPT.ATTRIBUTE10 ATTRIBUTE10
, OPT.ATTRIBUTE11 ATTRIBUTE11
, OPT.ATTRIBUTE12 ATTRIBUTE12
, OPT.ATTRIBUTE13 ATTRIBUTE13
, OPT.ATTRIBUTE14 ATTRIBUTE14
, OPT.ATTRIBUTE15 ATTRIBUTE15
, TLOOK.MEANING OPTION_TYPE
, OLOOK.MEANING OPTION_STATUS_TYPE
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, OPT.OPTION_HISTORY_ID
, OPT.NEW_LEASE_CHANGE_ID
, 'N' CURRENT_FLAG
, OPT.OPTION_EXER_START_DATE OPTION_EXER_START_DATE
, OPT.OPTION_EXER_END_DATE OPTION_EXER_END_DATE
, OPT.OPTION_ACTION_DATE OPTION_ACTION_DATE
, OPT.OPTION_COST OPTION_COST
, OPT.OPTION_AREA_CHANGE OPTION_AREA_CHANGE
, OPT.OPTION_REFERENCE OPTION_REFERENCE
, OPT.OPTION_NOTICE_REQD OPTION_NOTICE_REQD
, OPT.OPTION_COMMENTS OPTION_COMMENTS
FROM MTL_UNITS_OF_MEASURE UOM
, FND_LOOKUPS TLOOK
, FND_LOOKUPS OLOOK
, PN_OPTIONS_HISTORY OPT
WHERE TLOOK.LOOKUP_TYPE = 'PN_LEASE_OPTION_TYPE'
AND TLOOK.LOOKUP_CODE = OPT.OPTION_TYPE_CODE
AND OLOOK.LOOKUP_TYPE = 'PN_OPTION_STATUS_TYPE'
AND OLOOK.LOOKUP_CODE = OPT.OPTION_STATUS_LOOKUP_CODE
AND UOM.UOM_CODE (+) = OPT.UOM_CODE

Columns