VIEW: APPS.OKL_REPAIR_COSTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')