XXEN_SCHUB_ITEM_CUSTOM_QUERY

➜ Back to Library
Description
Categories: Supply Chain Hub
Supply Chain Hub Form - Customer Extension Query to populate the configurable placeholder columns in the Items Tab with Customer Site Specific item information.

1. Modify the query to derive and populate the query select columns with your custom specific item information
2. Do not remove the organization_id or inventory_item_id select columns
3. Do not modify the column aliases
4. ...  Supply Chain Hub Form - Customer Extension Query to populate the configurable placeholder columns in the Items Tab with Customer Site Specific item information.

1. Modify the query to derive and populate the query select columns with your custom specific item information
2. Do not remove the organization_id or inventory_item_id select columns
3. Do not modify the column aliases
4. Do not modify or add and additional lexical parameters
5. Remove the where clause and 1=2
6. In Responsibility: CRM Administrator, Menu: Spreadtable - Metadata Administration, modify the spreadtable XXEN_SCHUB_ITEM_SEARCH_V datasource to:
- check the visible flag of the configurable columns populated in this query
- modify the Display Label of the populated columns as required to be displayed in the Item Tab
- modify the display sequence of the configurable columns as required
   more
Run XXEN_SCHUB_ITEM_CUSTOM_QUERY and other Oracle EBS reports with Blitz Report™ on our demo environment
select
  msib.organization_id
, msib.inventory_item_id
, to_number(null) num01
, to_number(null) num02
, to_number(null) num03
, to_number(null) num04
, to_number(null) num05
, null            char01
, null            char02
, null            char03
, null            char04
, null            char05
, to_date(null)   date01
, to_date(null)   date02
, to_date(null)   date03
, to_date(null)   date04
, to_date(null)   date05
from
   mtl_system_items_b msib
where
 1=1
 -- do not change or add additional lexical parameters 
&lp_organization_where
&lp_item_where
-- the following line prevents this template from returning data. 
-- remove when modifying the query to derive additional item data   
and 1=2
Parameter Name SQL text Validation
Organization 
and msib.organization_id = :p_organization_id
 LOV Oracle
Item 
and msib.inventory_item_id = :p_item_id
 LOV Oracle
Download
Related Blitz Reports
inventory item tracker Items ECC Cost Management, WIP Valuation (Process) ECC Procurement, Purchase Orders CAC WIP Jobs With Complete Status Which Are Ready for Close MAD1 new report items GMF MUV Detail GMD MUV Detail
Blitz Report™

Blitz Report™ provides multiple benefits: