eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_WF_UTIL_PVT dependencies on GR_INV_ITEM_PROPERTIES

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 1016: gr_inv_item_properties)

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
1019: AND a.item_code = V_item_code
1020: AND a.orgn_id = V_orgn_id