1. Tables and Views for Loyalty
  2. LOY_POINTS_EXPIRING_V

LOY_POINTS_EXPIRING_V

Details

  • Schema: FUSION

  • Object owner: LOY

  • Object type: VIEW

Columns

Name

PROGRAM_ID

MEMBER_ID

PROMO_ID

ATTRIB_DEFN_ID

PARTNER_ID

PROD_ID

POINTS_EXPIRING

EXPIRATION_DT

Query

SQL_Statement

SELECT MEM.PROGRAM_ID,

ACRL.MEMBER_ID,

ACRL.PROMO_ID,

ACRL.ATTRIB_DEFN_ID,

TXN.PARTNER_ID,

TXN.PROD_ID,

ACCRUALED_VALUE - nvl(USED_VALUE,0) POINTS_EXPIRING,

ACRL.EXPIRATION_DT

FROM LOY_ACRL_ITM ACRL

LEFT JOIN LOY_TXN TXN

ON ACRL.TXN_ID = TXN.LOY_TXN_ID

INNER JOIN LOY_MEMBER MEM

ON ACRL.MEMBER_ID = MEM.LOY_MEMBER_ID

WHERE ACRL.EXPIRATION_DT >= SYSDATE