GR Properties

➜ Back to Library
Description
Categories: BI Publisher
Application: Process Manufacturing Regulatory Management
Source: Properties Report (XML)
Short Name: GRRPT050_XML
DB package: GR_GRRPT050_XMLP_PKG
Run GR Properties and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT A.LANGUAGE,
                          A.LANG_DESC,
                          A.PROPERTY_ID,
                          B.PROPERTY_TYPE_INDICATOR TYPE,
                          B.LENGTH,
                          B.PRECISION,
                          A.PROPERTY_DESC,
                          B.RANGE_MIN,
                          B.RANGE_MAX,
                          DECODE(C.VALUE, NULL, 'N', 'Y') DISPLAY,
                          C.DISPLAY_ORDER,
                          C.VALUE,
                          C.MEANING
            FROM   GR_PROPERTIES_TL_V             A,
                          GR_PROPERTIES_B                   B,
                          GR_PROPERTY_VALUES_TL   C
            where A.PROPERTY_ID =  B.PROPERTY_ID
            and     A.PROPERTY_ID =  C.PROPERTY_ID (+)
            and     (:P_PROPERTY_ID1 IS NULL OR A.PROPERTY_ID >= :P_PROPERTY_ID1)
            and     (:P_PROPERTY_ID2 IS NULL OR A.PROPERTY_ID <= :P_PROPERTY_ID2)
            and     A.LANGUAGE      =  C.LANGUAGE  (+)
            and     (:P_LANGUAGE1 IS NULL OR A.LANGUAGE >= :P_LANGUAGE1)
            and     (:P_LANGUAGE2 IS NULL OR A.LANGUAGE <= :P_LANGUAGE2)
            and     (:P_PROP_TYPE IS NULL OR  B.PROPERTY_TYPE_INDICATOR = :P_PROP_TYPE)
            order by  A.LANGUAGE, A.PROPERTY_ID,  C.DISPLAY_ORDER
Parameter Name SQL text Validation
From Property ID 
 
 LOV Oracle
To Property ID 
 
 LOV Oracle
Property Type 
 
 LOV Oracle
From Langage 
 
 LOV Oracle
To Language 
 
 LOV Oracle
Download
Related Blitz Reports
GR Hazard Classification Code Details GR Master Item Associations GR Field Name Codes GR Risk Phrases GR Field Name Class Codes GR Safety Phrases GMF Costed Indented Bill of Materials IGI Secondary Invoice Approval : Secondary Approval of Invoices - draft WSH Vehicle Load Sheet Details
Blitz Report™

Blitz Report™ provides multiple benefits: