Oracle Receivable Active Memo Line Query

 Background:

Run the following SQL Query to get all active AR Memo Lines.

Navigation: Receivables Manager > Setup > Transactions > Memo Lines

=> Set the Org context first.
begin
mo_global.set_policy_context('S',<org_id>);
end;
/



Script:


SELECT hou.name operating_unit,
       amlv.name,
       amlv.description,
       amlv.line_type type,
       amlv.tax_code tax_classification,
       amlv.uom_code unit_of_measure,
       amlv.unit_std_price unit_list_price,
       gcck.concatenated_segments revenue_account,
       amlv.start_date,
       amlv.end_date
  FROM ar_memo_lines_vl amlv,
       gl_code_combinations_kfv gcck,
       hr_operating_units hou
 WHERE     end_date IS NULL
       AND hou.organization_id = amlv.org_id
       AND amlv.GL_ID_REV = gcck.CODE_COMBINATION_ID;