[Home] [Help]
View: IBE_SH_QUOTE_ACCESS_EMAIL_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
, C.EMAIL_ADDRESS
, C.EMAIL_FORMAT
FROM HZ_CONTACT_POINTS C
, IBE_SH_QUOTE_ACCESS S
WHERE C.OWNER_TABLE_NAME = 'IBE_SH_QUOTE_ACCESS'
AND C.OWNER_TABLE_ID = S.QUOTE_SHAREE_ID
AND C.CONTACT_POINT_TYPE = 'EMAIL'
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 |
EMAIL_ADDRESS |
EMAIL_FORMAT |