FND Design Data [Home] [Help]

View: OKL_REPAIR_COSTS_V

Product: OKL - Lease and Finance Management
Description: Setup table to store types of repair and a recommended cost applicable to asset condition repairs
Implementation/DBA Data: ViewAPPS.OKL_REPAIR_COSTS_V
View Text

SELECT RPCB.ROWID ROW_ID
, RPCB.ID ID
, RPCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RPCT.SFWT_FLAG SFWT_FLAG
, RPCB.ENABLED_YN ENABLED_YN
, RPCB.COST COST
, RPCT.REPAIR_TYPE REPAIR_TYPE
, RPCT.DESCRIPTION DESCRIPTION
, RPCB.ORG_ID ORG_ID
, RPCB.CREATED_BY CREATED_BY
, RPCB.CREATION_DATE CREATION_DATE
, RPCB.LAST_UPDATED_BY LAST_UPDATED_BY
, RPCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RPCB.CURRENCY_CODE
, RPCB.CURRENCY_CONVERSION_CODE
, RPCB.CURRENCY_CONVERSION_TYPE
, RPCB.CURRENCY_CONVERSION_RATE
, RPCB.CURRENCY_CONVERSION_DATE
FROM OKL_REPAIR_COSTS_B RPCB
, OKL_REPAIR_COSTS_TL RPCT
WHERE RPCB.ID = RPCT.ID
AND RPCT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
ENABLED_YN
COST
REPAIR_TYPE
DESCRIPTION
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CURRENCY_CODE
CURRENCY_CONVERSION_CODE
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_DATE