This content has been marked as final. Show 2 replies
The ASL you are talking about is it a Local ASL or a Global ASL..
And as far as I remember we have something as using_organization_id which determines the Inv Org for which this ASL is defined.
If it is -1 its a Global ASL, else if its some other value its a Local ASL.
The PO_ASL_DOCUMENTS also has the USING_ORGANIZATION_ID column.
So by adding USING_ORGANIZATION_ID in the select clause you can check that if you are getting two rows because of different USING_ORGANIZATION_ID.
Remove the outer join in your queyr and check if it works?
and pol.po_line_id = doc.DOCUMENT_LINE_ID