GR Master Item Associations
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
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 |