View: OKL_AM_ASSET_CNDTN_LNS_UV

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

View Text

SELECT ACNB.ROWID ROW_ID
, ACNB.ID ID
, ACNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACNT.SFWT_FLAG SFWT_FLAG
, ACNB.CTP_CODE CTP_CODE
, ACNB.DTY_CODE DTY_CODE
, ACNB.CDN_CODE CDN_CODE
, ACNB.ACS_CODE ACS_CODE
, ACNB.ISQ_ID ISQ_ID
, ACNB.PZT_ID PZT_ID
, ACNB.ACD_ID ACD_ID
, ACNB.RPC_ID RPC_ID
, ACNB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, ACNT.DAMAGE_DESCRIPTION DAMAGE_DESCRIPTION
, ACNT.CLAIM_DESCRIPTION CLAIM_DESCRIPTION
, ACNB.ESTIMATED_REPAIR_COST ESTIMATED_REPAIR_COST
, ACNB.ACTUAL_REPAIR_COST ACTUAL_REPAIR_COST
, ACNB.APPROVED_BY APPROVED_BY
, ACNB.APPROVED_YN APPROVED_YN
, ACNB.DATE_APPROVED DATE_APPROVED
, ACNB.DATE_REPORTED DATE_REPORTED
, ACNT.RECOMMENDED_REPAIR RECOMMENDED_REPAIR
, ACNT.PART_NAME PART_NAME
, RPCT.REPAIR_TYPE
, RPCT.DESCRIPTION
, RPCB.COST REPAIR_COST
, FND1.MEANING STATUS_DESC
, FND2.MEANING CONDITION_DESC
, FND3.MEANING DAMAGE_DESC
, TIL.ACN_ID_COST ACN_ID_COST
, ACD.KLE_ID
, RPCB.ORG_ID RPC_ORG_ID
, ACNB.ORG_ID ACN_ORG_ID
FROM OKL_ASSET_CNDTN_LNS_B ACNB
, OKL_ASSET_CNDTN_LNS_TL ACNT
, OKL_ASSET_CNDTNS ACD
, OKL_REPAIR_COSTS_ALL_B RPCB
, OKL_REPAIR_COSTS_TL RPCT
, OKL_TXL_AR_INV_LNS_B TIL
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
, FND_LOOKUPS FND3
WHERE ACNB.ID = ACNT.ID
AND ACNT.LANGUAGE = USERENV('LANG')
AND ACD.ID = ACNB.ACD_ID
AND RPCB.ID = RPCT.ID (+)
AND RPCT.LANGUAGE (+) = USERENV('LANG')
AND ACNB.RPC_ID = RPCB.ID (+)
AND TIL.ACN_ID_COST (+) = ACNB.ID
AND FND1.LOOKUP_TYPE = 'OKL_ASSET_CNDN_LINE_STATUS'
AND FND1.LOOKUP_CODE = ACNB.ACS_CODE
AND FND2.LOOKUP_TYPE = 'OKL_ASSET_CONDITION'
AND FND2.LOOKUP_CODE = ACNB.CDN_CODE
AND FND3.LOOKUP_TYPE = 'OKL_DAMAGE_TYPE'
AND FND3.LOOKUP_CODE = ACNB.DTY_CODE

Columns