[Home] [Help]
View: IBE_SH_QUOTE_ACCESS_V
Product: | IBE - iStore |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT S.QUOTE_SHAREE_ID
, S.REQUEST_ID
, S.PROGRAM_APPLICATION_ID
, S.PROGRAM_ID
, S.PROGRAM_UPDATE_DATE
, S.OBJECT_VERSION_NUMBER
, S.CREATED_BY
, S.CREATION_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATE_LOGIN
, S.QUOTE_HEADER_ID
, S.QUOTE_SHAREE_NUMBER
, S.UPDATE_PRIVILEGE_TYPE_CODE
, L.MEANING
FROM IBE_SH_QUOTE_ACCESS S
, ASO_QUOTE_HEADERS_ALL Q
, FND_LOOKUPS L
WHERE S.QUOTE_HEADER_ID = Q.QUOTE_HEADER_ID
AND S.UPDATE_PRIVILEGE_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'IBE_QUOTE_UPDATE_PRIVILEGE'
Columns
Name |
QUOTE_SHAREE_ID |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
QUOTE_HEADER_ID |
QUOTE_SHAREE_NUMBER |
UPDATE_PRIVILEGE_TYPE_CODE |
MEANING |