Product: | AMS - Marketing |
---|---|
Description: | View that joins affiliate posting information and translable fields. |
Implementation/DBA Data: | Not implemented in this database |
SELECT APB.POSTING_ID
, APB.CREATED_BY
, APB.CREATION_DATE
, APB.CUSTOMER_PARTY_ID
, APB.OBJECT_VERSION_NUMBER
, 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
, APB.ENABLED_FLAG
, APTL.OBJECT_VERSION_NUMBER TL_OBJECT_VERSION_NUMBER
, APTL.POSTING_NAME
, APTL.DESCRIPTION
FROM AMS_IBA_POSTINGS_B APB
, AMS_IBA_POSTINGS_TL APTL
WHERE APTL.POSTING_ID (+) = APB.POSTING_ID
AND APTL.LANGUAGE(+) = USERENV('LANG')
AND APB.ENABLED_FLAG = 'Y'