Hi
i have extended a view object APInvDistAllVO by adding two fields which are functions. Basically in the invoice approval screen I want to add two fields where the invoice distribution is shown.
the SQL query appearing in jdeveloper when extending the VO Object is different to the query what I see in the invoice approval page when clicking on the APInvDistAllVO link. There are two bind variables :1 = invoice_id and :2 = line_number being dynamically added.
After extending the view object, the invoice distribution line shows as no records found. I feel this is due to the bind variables not having the correct parameters being passed, and as this view object is a dependent object based in the invoice header record.
WIll be very thankful if someone can provide the way forward In handling this situation.
Rgds
Fahad