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