Demand Planning Macros Help

Hello Experts!!!

I am having difficulty to define the below alerts/macros in Demand Planning. Can someone please let me know the logic for creating them.

1. List of DFU's having multiple locations in a region.

2. List of DFU's having default Constant Model

3. List of phase-out products without a phase-out profile. (product status is being maintained to identify the phasing-out products)

4. When a phase-in or phase-out profile has expired.

Thanks in Advance.

Regards,

Venkat