FND Design Data [Home] [Help]

View: OKL_RELOCATE_ASSETS_V

Product: OKL - Lease and Finance Management
Description: Represents the shipping instructions of an asset determined during the asset return process
Implementation/DBA Data: ViewAPPS.OKL_RELOCATE_ASSETS_V
View Text

SELECT RASB.ROWID ROW_ID
, RASB.ID ID
, RASB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RAST.SFWT_FLAG SFWT_FLAG
, RASB.ART_ID ART_ID
, RASB.PAC_ID PAC_ID
, RASB.IST_ID IST_ID
, RASB.DATE_SHIPPING_INSTRUCTIONS_SEN DATE_SHIPPING_INSTRUCTIONS_SEN
, RAST.COMMENTS COMMENTS
, RASB.TRANS_OPTION_ACCEPTED_YN TRANS_OPTION_ACCEPTED_YN
, RASB. INSURANCE_AMOUNT INSURANCE_AMOUNT
, RASB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RASB.ATTRIBUTE1 ATTRIBUTE1
, RASB.ATTRIBUTE2 ATTRIBUTE2
, RASB.ATTRIBUTE3 ATTRIBUTE3
, RASB.ATTRIBUTE4 ATTRIBUTE4
, RASB.ATTRIBUTE5 ATTRIBUTE5
, RASB.ATTRIBUTE6 ATTRIBUTE6
, RASB.ATTRIBUTE7 ATTRIBUTE7
, RASB.ATTRIBUTE8 ATTRIBUTE8
, RASB.ATTRIBUTE9 ATTRIBUTE9
, RASB.ATTRIBUTE10 ATTRIBUTE10
, RASB.ATTRIBUTE11 ATTRIBUTE11
, RASB.ATTRIBUTE12 ATTRIBUTE12
, RASB.ATTRIBUTE13 ATTRIBUTE13
, RASB.ATTRIBUTE14 ATTRIBUTE14
, RASB.ATTRIBUTE15 ATTRIBUTE15
, RASB.ORG_ID ORG_ID
, RASB.REQUEST_ID REQUEST_ID
, RASB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, RASB.PROGRAM_ID PROGRAM_ID
, RASB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RASB.CREATED_BY CREATED_BY
, RASB.CREATION_DATE CREATION_DATE
, RASB.LAST_UPDATED_BY LAST_UPDATED_BY
, RASB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RASB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RASB.CURRENCY_CODE
, RASB.CURRENCY_CONVERSION_CODE
, RASB.CURRENCY_CONVERSION_TYPE
, RASB.CURRENCY_CONVERSION_RATE
, RASB.CURRENCY_CONVERSION_DATE
FROM OKL_RELOCATE_ASSETS_B RASB
, OKL_RELOCATE_ASSETS_TL RAST
WHERE RASB.ID = RAST.ID
AND RAST.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
ART_ID
PAC_ID
IST_ID
DATE_SHIPPING_INSTRUCTIONS_SEN
COMMENTS
TRANS_OPTION_ACCEPTED_YN
INSURANCE_AMOUNT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ORG_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
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