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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
CAC WIP Material Usage with Configuration and Lot Variances CAC Manufacturing Variance Detail CAC Manufacturing Variance Summary INV Item Upload Andy INV Item Upload - Default Andy INV Item Upload - General Planning WSH Pick Slip CAC Inventory and Intransit Value (Period-End) - Discrete/OPM CAC Calculate Average Item Costs CAC ICP PII Inventory Pending Cost Adjustment
Blitz Report™

Blitz Report™ provides multiple benefits: