APPS.GR_WF_UTIL_PVT dependencies on GR_XML_PROPERTIES_MAP

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

Line 1014: FROM gr_prop_chng_temp a, gr_xml_properties_map b, mtl_system_items_kfv c

1010: AND c.xml_element = V_element_name
1011: AND d.message_icn = p_message_icn
1012: UNION ALL
1013: SELECT a.property_name, NULL property_value, a.property_value Proposed_value
1014: FROM gr_prop_chng_temp a, gr_xml_properties_map b, mtl_system_items_kfv c
1015: WHERE (c.inventory_item_id, c.organization_id, b.field_name_code, b.property_id ) NOT IN (select INVENTORY_ITEM_ID , ORGANIZATION_ID , label_code, property_id from
1016: gr_inv_item_properties)
1017: AND a.property_name = b.xml_element
1018: AND a.property_name = V_element_name

Line 1029: WHERE property_name NOT IN (SELECT xml_element FROM gr_xml_properties_map)

1025:
1026: CURSOR get_unmap_property_value (V_orgn_id NUMBER, V_item_code VARCHAR2, V_element_name VARCHAR2) IS
1027: SELECT property_name, NULL property_value, property_value Proposed_value
1028: FROM gr_prop_chng_temp
1029: WHERE property_name NOT IN (SELECT xml_element FROM gr_xml_properties_map)
1030: AND property_name = V_element_name
1031: AND item_code = V_item_code
1032: AND orgn_id = V_orgn_id
1033: AND message_icn = p_message_icn;