Product: | AMS - Marketing |
---|---|
Description: | View that joins posting information and translable fields. |
Implementation/DBA Data: | Not implemented in this database |
SELECT APB.POSTING_ID
, APB.CREATED_BY
, APB.CREATION_DATE
, APB.LAST_UPDATED_BY
, APB.LAST_UPDATE_DATE
, APB.LAST_UPDATE_LOGIN
, APB.OBJECT_VERSION_NUMBER
, APB.CUSTOMER_PARTY_ID
, APB.AFFILIATE_PARTY_ID
, APB.DELIVERABLE_ID
, APB.DISPLAY_RULE_ID
, APB.EFFECTIVE_START_DATE
, APB.EFFECTIVE_END_DATE
, APB.AFFILIATE_NUMBER
, APB.SEND_FOR_PREVIEW_FLAG
, APB.DIRECTION
, APB.PRESENTATION_URL
, APB.CONTENT_SITE
, APB.AFFILIATE_STYLE_SHEET
, APB.DISPLAY_PROGRAM
, APB.IMPRESSION_COUNT
, APB.MAX_IMPRESSION_COUNT
, APB.CAMPAIGN_TYPE
, APB.POSTING_TYPE
, APB.STATUS_CODE
, APB.DEFAULT_CAMPAIGN_ID
, APB.CHARGEBACK_UOM
, APB.CHARGEBACK_AMOUNT_CURR_CODE
, APB.CHARGEBACK_AMOUNT
, APB.OWNER_ID
, APB.ORG_ID
, APB.SEGMENT_OVERRIDE_FLAG
, APB.MAX_CAMPAIGNS
, APTL.OBJECT_VERSION_NUMBER TL_OBJECT_VERSION_NUMBER
, APTL.POSTING_NAME
, APTL.DESCRIPTION
, HZP.PARTY_NAME
, APB.AVAILABLE_ON_OBJECT_ID
, APB.AVAILABLE_ON_OBJECT_TYPE
FROM AMS_IBA_POSTINGS_B APB
, AMS_IBA_POSTINGS_TL APTL
, HZ_PARTIES HZP
WHERE APTL.POSTING_ID (+) = APB.POSTING_ID
AND APTL.LANGUAGE(+) = USERENV('LANG') AND HZP.PARTY_ID(+) = APB.AFFILIATE_PARTY_ID
AND APB.ENABLED_FLAG = 'Y'