View: OKL_AM_ASSET_TRACK_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_ASSET_TRACK_UV

View Text

SELECT KHR.ID ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.START_DATE CONTRACT_START_DATE
, KHR.END_DATE CONTRACT_END_DATE
, KHR.DESCRIPTION CONTRACT_DESCRIPTION
, KHR.STS_CODE STS_CODE
, OKS.MEANING CONTRACT_STATUS
, PFC.KHR_ID KHR_ID
, PFL.TRX_STATUS_CODE TRX_STATUS_CODE
, FND1.MEANING TRANSACTION_STATUS
, PFL.ASSET_TRACK_STRATEGY_CODE ASSET_TRACK_STRATEGY_CODE
, FND2.MEANING STRATEGY_DESCRIPTION
, PFL.DATE_STRATEGY_EXECUTION_DUE DATE_STRATEGY_EXECUTION_DUE
, PFL.BUDGET_AMOUNT BUDGET_AMOUNT
, PFL.DATE_STRATEGY_EXECUTED DATE_STRATEGY_EXECUTED
, PFL.TMB_ID TMB_ID
, PFL.FMA_ID FMA_ID
, PFL.COMMENTS COMMENTS
, JTV.DISPLAY_NAME ASSINGMENT_GROUP
, PFL.PFC_ID PFC_ID
, PFL.ID PFL_ID
, PFL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKL_K_HEADERS_FULL_V KHR
, OKL_PRTFL_CNTRCTS_V PFC
, OKL_PRTFL_LINES_V PFL
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, OKC_STATUSES_V OKS
, OKL_AM_PORTFOLIO_TEAMS_UV JTV
WHERE KHR.ID = PFC.KHR_ID
AND PFC.ID = PFL.PFC_ID
AND KHR.STS_CODE = OKS.CODE
AND PFL.TMB_ID = JTV.ORIG_SYSTEM_ID
AND PFL.TRX_STATUS_CODE = FND1.LOOKUP_CODE
AND FND1.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND PFL.ASSET_TRACK_STRATEGY_CODE = FND2.LOOKUP_CODE
AND FND2.LOOKUP_TYPE = 'OKL_ASSET_TRACK_STRATEGIES'

Columns