SQL Final Statement

When done with JOIN and ORDER BY, you can save your statement locally.

Example based on the scenarios presented in the previous topics:

Example of a final Invoice Line Item SQL Statement:

SELECT inv_li.RECORD_ID AS inv_li_record_no,

inv_li.LI_NUM AS inv_li_no,

inv_li.SHORT_DESC AS inv_li_desc,

inv_li.UUU_UNIT_PRICE AS inv_li_unit_price,

inv_li.UUU_QUANTITY AS inv_li_quantity,

inv_li.AMOUNT AS inv_li_amount,

sdo.OPTION_NAME AS inv_li_uom,

bi.CODE,

bi.ITEM

FROM unifier_ui_lineitem inv_li

LEFT JOIN SYS_DATA_OPTION sdo

ON inv_li.UGENUNITOFMEASUREPD = sdo.OPTION_VALUE

AND (sdo.DATA_NAME = 'Unit of Measure'

AND sdo.REGISTRY = 'unifier')

LEFT JOIN unifier_budgetitem bi

ON inv_li.BITEMID = bi.BITEMID

AND inv_li.BUDGETID = bi.BUDGETID

ORDER BY inv_li_record_no, inv_li.LI_NUM



Legal Notices
Copyright © 2016, 2018, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 28, 2018