Production Ticket(ST) #11777
KYMMSENG - No have promotion list
1) Check the customer created date.
2) Check the customer promo qualifier.
3) Try simulate the issue.
4) Found no issue to show the promo list.
Root cause: No issue found.
None
Description
No have promotion list
History
#1 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 22/05/2024
- Resolution updated (diff)
select * from customer where customer_name like '%ONE GLORY ENTERPRISE%'
select * from product_item where item_code = '14007297'
select * from member where member_cd = 'sr05'
select * from mobile_promotion_customer_qualifier where customer_id = 'b41654c6-2368-4020-b829-a8ea3fe305b9'
select * from mobile_promotion_product_qualifier where product_id = '00788438B39B4B67A04613334895AA75'
select at_type, * from mobile_promotion_product_qualifier_at --where product_id = '00788438B39B4B67A04613334895AA75'
order by at_date desc
select promition_code, * from mobile_promotion_customer_qualifier a
inner join mobile_promotion_header b on b.promotion_id = a.promotion_id
where a.customer_id = 'b41654c6-2368-4020-b829-a8ea3fe305b9'
and a.promotion_id = '374c9ce3b7264299b74a268b32c799bd'
select * from mobile_promotion_header
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100