Need SQL For PO Item Details Along With GL CODE COMBINATIONS

(Doc ID 2217572.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Building PO item details along with gl_code_combinations
Need inventory tables along with the join condition for code_combination_id from GL_CODE_COMBINATIONS.

The requirement is to build PO item details along with gl_code_combinations. Please let us know all the inventory tables along with the join condition for code_combination_id from GL_CODE_COMBINATIONS.

The below columns should be listed in report.

Item_Number,
Item_Description,
Taxable_Flag,
Expense_Code,
Active_Status.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms