VIEW: APPS.OKL_AM_ASSET_TRACK_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'