[Home] [Help]
View: IGW_PROP_PROGRAM_ADDRESSES_V
Product: | IGW - Grants Proposal |
Description: | 10SC Only |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT P.ROWID
, P.PROPOSAL_ID
, P.ADDRESS_ID
, REPLACE(REPLACE(A.ADDRESS1||'
, '|| A.ADDRESS2||'
, '|| A.ADDRESS3||'
, '|| A.ADDRESS4||'
, '|| A.CITY||'
, '|| A.STATE||'
, '|| A.POSTAL_CODE
, '
,
, '
, '
, ')
, '
,
, '
, '
, ') MAILING_ADDRESS
, P.NUMBER_OF_COPIES
, P.MAIL_DESCRIPTION
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
FROM IGW_PROP_PROGRAM_ADDRESSES P
, RA_ADDRESSES A
WHERE A.ADDRESS_ID(+) = P.ADDRESS_ID
Columns
Name |
ROW_ID |
PROPOSAL_ID |
ADDRESS_ID |
MAILING_ADDRESS |
NUMBER_OF_COPIES |
MAIL_DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |