View: GR_OTHER_PROPERTY_XML

Product:	GR - Process Manufacturing Regulatory Management
Description:	View for Inventory Item and its associated Other Physical Properties details
Implementation/DBA Data:	APPS.GR_OTHER_PROPERTY_XML

View Text

SELECT A.ORGANIZATION_ID ORGNID
, A.INVENTORY_ITEM_ID ITEMID
, A.LABEL_CODE LABELCODE
, E.DESCRIPTION PROPERTYNAME
, DECODE(B.PROPERTY_TYPE_INDICATOR
, 'F'
, G.MEANING
, 'A'
, A.ALPHA_VALUE
, 'N'
, TO_CHAR(A.NUMBER_VALUE)
, 'D'
, TO_CHAR(A.DATE_VALUE)) PROPERTYVALUE
FROM GR_INV_ITEM_PROPERTIES A
, GR_PROPERTIES_B B
, GR_PROPERTIES_TL E
, GR_PROPERTY_VALUES_TL G
WHERE (A.PROPERTY_ID = B.PROPERTY_ID
AND A.PROPERTY_ID = E.PROPERTY_ID
AND B.PROPERTY_ID = E.PROPERTY_ID
AND E.LANGUAGE = USERENV('LANG')
AND B.PROPERTY_TYPE_INDICATOR IN ('N'
, 'D'
, 'A')
AND (A.LABEL_CODE
, A.PROPERTY_ID) NOT IN ( SELECT FIELD_NAME_CODE
, PROPERTY_ID
FROM GR_XML_PROPERTIES_MAP)) OR ( B.PROPERTY_TYPE_INDICATOR = 'F'
AND G.LANGUAGE = USERENV('LANG')
AND E.LANGUAGE = USERENV('LANG')
AND A.PROPERTY_ID = G.PROPERTY_ID
AND B.PROPERTY_ID = G.PROPERTY_ID
AND A.PROPERTY_ID = E.PROPERTY_ID
AND B.PROPERTY_ID = E.PROPERTY_ID
AND E.PROPERTY_ID = G.PROPERTY_ID
AND A.ALPHA_VALUE = G.VALUE
AND (A.LABEL_CODE
, A.PROPERTY_ID) NOT IN ( SELECT FIELD_NAME_CODE
, PROPERTY_ID
FROM GR_XML_PROPERTIES_MAP)) GROUP BY A.ORGANIZATION_ID
, A.INVENTORY_ITEM_ID
, A.LABEL_CODE
, E.DESCRIPTION
, DECODE(B.PROPERTY_TYPE_INDICATOR
, 'F'
, G.MEANING
, 'A'
, A.ALPHA_VALUE
, 'N'
, TO_CHAR(A.NUMBER_VALUE)
, 'D'
, TO_CHAR(A.DATE_VALUE))

Columns