DBA Data[Home] [Help]

APPS.GR_WF_UTIL_PVT dependencies on GR_PROPERTIES_B

Line 1000: FROM gr_inv_item_properties a, gr_properties_b b, gr_xml_properties_map c, gr_prop_chng_temp d

996:
997: CURSOR get_property_value (V_orgn_id NUMBER, V_item_code VARCHAR2, V_element_name VARCHAR2) IS
998: SELECT d.property_name, DECODE(b.property_type_indicator, 'A', a.alpha_value, 'D', a.date_value, 'N', a.number_value, 'F', a.alpha_value ) property_value,
999: d.property_value Proposed_value
1000: FROM gr_inv_item_properties a, gr_properties_b b, gr_xml_properties_map c, gr_prop_chng_temp d
1001: WHERE a.property_id = b.property_id
1002: AND a.property_id = c.property_id
1003: AND b.property_id = c.property_id
1004: AND a.label_code = c.field_name_code