GR Master Item Associations

Categories: BI Publisher
Application: Process Manufacturing Regulatory Management
Source: Master Item Associations Report (XML)
Short Name: GRRPT028_XML
DB package: GR_GRRPT028_XMLP_PKG

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 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