GR Master Item Associations

➜ Back to Library
XLSExcel example XMLXML import file

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

SQL 9 lines

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

Parameters 2

ParameterTypeList of values SQL
From Master Regulatory ItemLOV Oracle
To Master Regulatory ItemLOV Oracle