GR Properties

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Regulatory Management
Source: Properties Report (XML)
Short Name: GRRPT050_XML
DB package: GR_GRRPT050_XMLP_PKG
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
To Language
 
LOV Oracle
From Langage
 
LOV Oracle
Property Type
 
LOV Oracle
To Property ID
 
LOV Oracle
From Property ID
 
LOV Oracle