Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the label property code. |
Implementation/DBA Data: | APPS.GR_LABEL_PROP_V |
SELECT LP.ROWID ROW_ID
, LP.PROPERTY_ID
, LP.LABEL_CODE
, LP.SEQUENCE_NUMBER
, PT.LANGUAGE
, PT.DESCRIPTION
, PB.PROPERTY_TYPE_INDICATOR
, PB.LENGTH
, PB.RANGE_MIN
, PB.RANGE_MAX
, PB.PRECISION
, LP.ROLLUP_TYPE
, LP.PROPERTY_REQUIRED
, LP.CREATED_BY
, LP.CREATION_DATE
, LP.LAST_UPDATED_BY
, LP.LAST_UPDATE_DATE
, LP.LAST_UPDATE_LOGIN
FROM GR_PROPERTIES_B PB
, GR_LABEL_PROPERTIES LP
, GR_PROPERTIES_TL PT
WHERE LP.PROPERTY_ID = PB.PROPERTY_ID
AND PB.PROPERTY_ID = PT.PROPERTY_ID