GR Master Item Associations

➜ Back to Library
Description
Categories: BI Publisher
Application: Process Manufacturing Regulatory Management
Source: Master Item Associations Report (XML)
Short Name: GRRPT028_XML
DB package: GR_GRRPT028_XMLP_PKG
Run GR Master Item Associations and other Oracle EBS reports with Blitz Report™ on our demo environment
select a.item_code, b.name_description
            from gr_item_general a, gr_multilingual_name_tl b
            where a.item_code = b.item_code
            and (:P_generic_select1 is null or a.item_code >= :P_generic_select1)
            and(:P_generic_select2 is null or a.item_code <= :P_generic_select2)
            and b.label_code = '11007'
            and b.language = userenv('LANG')
            order by 1
Parameter Name SQL text Validation
From Master Regulatory Item 
 
 LOV Oracle
To Master Regulatory Item 
 
 LOV Oracle
Download
 
Related Blitz Reports
GMF Costed Indented Bill of Materials WSH Vehicle Load Sheet Summary WSH Vehicle Load Sheet Summary PDF Output WSH Vehicle Load Sheet Details GR Hazard Classification Code Details GR Properties GR Field Name Codes GR Safety Phrases GR Field Name Class Codes
Blitz Report™

Blitz Report™ provides multiple benefits: