GR Master Item Associations

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Regulatory Management
Source: Master Item Associations Report (XML)
Short Name: GRRPT028_XML
DB package: GR_GRRPT028_XMLP_PKG
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
To Master Regulatory Item
 
LOV Oracle
From Master Regulatory Item
 
LOV Oracle