Cannot select a fixed price line type when creating a complex PO in R12.1.3
Hello all,
We met a problem when trying to create a complex PO in R12.1.3.
We defined a fixed price line type in Purchasing, along with a seeded fixed price temp labor line type. But when we entered a complex PO lines (BWC > Orders > Lines), there's only one quantity basis line type(Goods) to choose. Neither fixed price line types were shown in the LOV.
We checked the LOV sql and found the following line:
WHERE (order_type_lookup_code NOT IN ('FIXED PRICE', 'RATE'))
If we disable this line, we could retrieve all three line types mentioned above.
We found two Metalink documents that are on this topic: