Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- WEEK_END_DATE
- , CAMPAIGN_CODE
- , CAMPAIGN_VERSION
- , ASSIGNMENT_ID
- , ADVERTISER_ID
- , METRO_ASS_PREV_REV_AMT
- , METRO_PREV_REV_AMT
- , METRO_CURR_REV_AMT
- , METRO_RENEWAL_RATE_UP_AMT
- , METRO_PAID_IND
- , METRO_HANDLED_IND
- , METRO_BANK_IND
- , METRO_FIRST_YR_IND
- , METRO_CANCELLED_IND
- FROM
- PSTDR.SLS_SC_ADV_DIRECTORY_GRP_1_VW
- WHERE
- METRO_ASS_PREV_REV_AMT > 0
- -- AND METRO_BANK_IND IN ('I','D','R','C')
- AND METRO_BANK_IND = 'C'
- AND TO_CHAR(WEEK_END_DATE,'YYYY-MM-DD') = '2011-09-04'
- AND CAMPAIGN_CODE IN ('YPSEL1','YPSEL2')
Add Comment
Please, Sign In to add comment