VIEW: APPS.OKL_AM_ASSET_CNDTN_LNS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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