This piece plays in scenes pertaining to the God of Fate in Elancia Chronicles: Order of New Gods. It also will play during nightmare scenes that are a somewhat indirect result of the aforementioned god on a certain character. This character has a series of nightmares in which they slaughter everyone that ends up joining their traveling party. Fun times!
If you can't tell, I'm a huge Yasunori Mitsuda fan (Chrono Cross and Xenogears influenced this piece heavily.)