Find out which promotion applied to order using SQL queries.

Key Tables :

1.ORDADJUST
2. CLCDPROMO
3. PX_PROMOTION


Select CALCODE_ID from ORDADJUST where ORDERS_ID= 12345;

- this will return CALCODE_ID value and same need to pass in 2nd query, say suppose value we got as 98765

Select PX_PROMOTION_ID from CLCDPROMO where CALCODE_ID = 98765

- This will return PX_PROMOTION_ID value example we got value as 4321.

Select NAME,CODE from PX_PROMOTION where PX_PROMOTION_ID=4321;

- Here you will get the name and code of promotion which is applied for order.

Store Level promotion :

If you want to see for particular store what all promotion are there for customer.

Select * from PX_CDPOOL where STORE_ID = ?

Select PX_PROMOTION_ID from PX_CDPROMO where PX_CDPOOL_ID= ?

Select * from PX_PROMOTION where PX_PROMOTION_ID = ?

Detail promotion applied on order :

Select DETAIL from PX_PROMOARG from ORDERS_ID = ?