Hi All,My requirement...

Hi All,

My requirement for 11.5.10.2 as follows .

If the Order type is INTERNAL ORDER - US or INTERNAL ORDER - IRE or the Price LIST at the SO line is ZERO PRICE .

THEN
1. using Price list on the SO header search for the price list line with the item id from the line, where the so line pricing date falls within the from and to dates.

IF NULL
2. using Price list on the SO header search for the price list line with the category id from the item on the line (see below), where the so line pricing date falls within the from and to dates.

IF NULL
3. using Price list on the SO line go to first secondary price list repeat number 1

IF NULL
4. using Price list on the SO line go to first secondary price list repeat number 2

IF NULL
5. using Price list on the SO line go to next secondary price list repeat number 1
repeat for all listed secondary price lists.

I am very new to oracle pricing Kindly suggest table information or any sample script.

Thanks,
Pasupuleti.