Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ($P{SELECTED_EFFECTIVE_DATE}.equal("true")
- AND $P{SELECTED_THROUGH_DATE}.equal("true")) ?
- SELECT PRD.PRD_IND AS PRODUCT_NM,PRD.PRD_DS AS PRODUCT_DESC,OFR.OFFR_DESC
- AS OFFR_DESC,
- PRH.PRC_STA_DT AS START_DATE,PRH.PRC_END_DT AS END_DATE,SEU.SELL_UNIT_ID
- AS SELL_UNIT_ID,SEU.SELL_UNIT_NAME
- FROM $P!{EPISYS_SCHEMA}EPS_PRICE_HDR PRH
- INNER JOIN $P!{SCHEMA}EPS_EV_HDR EV ON EV.EPS_UID = PRH.EV_UID
- INNER JOIN $P!{SCHEMA}EPS_PRD_HDR PRD ON PRD.PRD_TYP_CD = PRH.PRD_TYP_CD
- AND PRD.PRD_CD = PRH.PRD_CD
- INNER JOIN $P!{SCHEMA}EPS_OFFR_HDR OFR ON OFR.EPS_UID = PRH.PRC_OFFR_ID
- INNER JOIN $P!{SCHEMA}EPS_SELL_UNIT SEU ON SEU.SELL_UNIT_ID = PRH.STR_GRP_ID
- WHERE EV.EV_TYP_CD = 'P'
- AND PRD.PRD_TYP_CD='SKU'
- AND PRH.ACTION != 'D'
- AND SEU.SELL_UNIT_ID= $P{SELL_UNIT_ID_STRING}
- AND (PRH.PRC_STA_DT BETWEEN TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
- AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd'))
- OR(PRH.PRC_END_DT BETWEEN TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
- AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd'))
- OR (PRH.PRC_STA_DT < TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
- AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd') < PRH.PRC_END_DT)
- ORDER BY PRH.PRC_STA_DT,PRD.PRD_DS
Add Comment
Please, Sign In to add comment