eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: OE_PRICE_LISTS_VL
Product: QP - Advanced Pricing
Description: Price List information. Displays the translated columns on List Headers in the local language. Provided for backward compatibility for other applications.
Implementation/DBA Data:
APPS.OE_PRICE_LISTS_VL
View Text
SELECT ROW_ID , PRICE_LIST_ID , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , REQUEST_ID , CURRENCY_CODE , ROUNDING_FACTOR , SECONDARY_PRICE_LIST_ID , SHIP_METHOD_CODE , FREIGHT_TERMS_CODE , TERMS_ID , START_DATE_ACTIVE , END_DATE_ACTIVE , COMMENTS , CONTEXT , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , NAME , DESCRIPTION , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL FROM QP_PRICE_LISTS_V
Columns
Name
ROW_ID
PRICE_LIST_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
CURRENCY_CODE
ROUNDING_FACTOR
SECONDARY_PRICE_LIST_ID
SHIP_METHOD_CODE
FREIGHT_TERMS_CODE
TERMS_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
COMMENTS
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
NAME
DESCRIPTION
TP_ATTRIBUTE1
TP_ATTRIBUTE2
TP_ATTRIBUTE3
TP_ATTRIBUTE4
TP_ATTRIBUTE5
TP_ATTRIBUTE6
TP_ATTRIBUTE7
TP_ATTRIBUTE8
TP_ATTRIBUTE9
TP_ATTRIBUTE10
TP_ATTRIBUTE11
TP_ATTRIBUTE12
TP_ATTRIBUTE13
TP_ATTRIBUTE14
TP_ATTRIBUTE15
TP_ATTRIBUTE_CATEGORY