[Home] [Help]
View: AS_PRICE_LISTS_V
Product: | AS - Sales Foundation |
Description: | Price lists view |
Implementation/DBA Data: |
APPS.AS_PRICE_LISTS_V
|
View Text
SELECT ASPRICE.ROWID
, ASGROUP.GROUP_ID
, ASGROUP.GROUP_NAME
, ASPRICE.PRICE_LIST_ID
, SOPRICE.NAME
, ASPRICE.DESCRIPTION
, SOPRICE.CURRENCY_CODE
, ASPRICE.LAST_UPDATE_DATE
, ASPRICE.LAST_UPDATED_BY
, ASPRICE.CREATION_DATE
, ASPRICE.CREATED_BY
, ASPRICE.LAST_UPDATE_LOGIN
FROM AS_PRICE_LISTS ASPRICE
, AS_PRICE_LIST_GROUPS ASGROUP
, SO_PRICE_LISTS_VL SOPRICE
WHERE ASPRICE.GROUP_ID = ASGROUP.GROUP_ID
AND ASPRICE.PRICE_LIST_ID = SOPRICE.PRICE_LIST_ID
Columns
Name |
ROW_ID |
GROUP_ID |
GROUP_NAME |
PRICE_LIST_ID |
NAME |
DESCRIPTION |
CURRENCY_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |