Product: | OKL - Lease and Finance Management |
---|---|
Description: | The line of a condition report detailing the item description and damage |
Implementation/DBA Data: | APPS.OKL_ASSET_CNDTN_LNS_V |
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
, ACNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ACNB.ATTRIBUTE1 ATTRIBUTE1
, ACNB.ATTRIBUTE2 ATTRIBUTE2
, ACNB.ATTRIBUTE3 ATTRIBUTE3
, ACNB.ATTRIBUTE4 ATTRIBUTE4
, ACNB.ATTRIBUTE5 ATTRIBUTE5
, ACNB.ATTRIBUTE6 ATTRIBUTE6
, ACNB.ATTRIBUTE7 ATTRIBUTE7
, ACNB.ATTRIBUTE8 ATTRIBUTE8
, ACNB.ATTRIBUTE9 ATTRIBUTE9
, ACNB.ATTRIBUTE10 ATTRIBUTE10
, ACNB.ATTRIBUTE11 ATTRIBUTE11
, ACNB.ATTRIBUTE12 ATTRIBUTE12
, ACNB.ATTRIBUTE13 ATTRIBUTE13
, ACNB.ATTRIBUTE14 ATTRIBUTE14
, ACNB.ATTRIBUTE15 ATTRIBUTE15
, ACNB.ORG_ID ORG_ID
, ACNB.REQUEST_ID REQUEST_ID
, ACNB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ACNB.PROGRAM_ID PROGRAM_ID
, ACNB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ACNB.CREATED_BY CREATED_BY
, ACNB.CREATION_DATE CREATION_DATE
, ACNB.LAST_UPDATED_BY LAST_UPDATED_BY
, ACNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACNB.CURRENCY_CODE
, ACNB.CURRENCY_CONVERSION_CODE
, ACNB.CURRENCY_CONVERSION_TYPE
, ACNB.CURRENCY_CONVERSION_RATE
, ACNB.CURRENCY_CONVERSION_DATE
FROM OKL_ASSET_CNDTN_LNS_B ACNB
, OKL_ASSET_CNDTN_LNS_TL ACNT
WHERE ACNB.ID = ACNT.ID
AND ACNT.LANGUAGE = USERENV('LANG')