VIEW: APPS.GR_OTHER_PROPERTY_XML

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))