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 MTL_SYSTEM_ITEMS_KFV

Line 294: FROM mtl_system_items_kfv

290: /* Used to get the item information */
291:
292: CURSOR get_item_details IS
293: SELECT concatenated_segments, description
294: FROM mtl_system_items_kfv
295: WHERE organization_id = p_orgn_id
296: AND inventory_item_id = p_item_id
297: AND hazardous_material_flag = 'Y';
298:

Line 1005: AND a.inventory_item_id = ( select inventory_item_id from mtl_system_items_kfv where organization_id =v_orgn_id and concatenated_segments =d.item_code )

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
1005: AND a.inventory_item_id = ( select inventory_item_id from mtl_system_items_kfv where organization_id =v_orgn_id and concatenated_segments =d.item_code )
1006: AND a.organization_id = d.orgn_id
1007: AND c.xml_element = d.property_name
1008: AND d.item_code = V_item_code
1009: AND d.orgn_id = V_orgn_id

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 1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c

1033: AND message_icn = p_message_icn;
1034:
1035: CURSOR gr_prop_chng_temp IS
1036: SELECT a.orgn_id, nvl(c.organization_code, ' ') orgn_code, a.item_code, b.description item_name, a.property_name
1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c
1038: WHERE a.orgn_id = b.organization_id
1039: AND a.orgn_id = c.organization_id
1040: AND b.organization_id = c.organization_id
1041: AND a.item_code = b.concatenated_segments

Line 1373: select concatenated_segments into l_from_item from mtl_system_items_kfv where rownum=1;

1369: itemkey => l_itemkey,
1370: aname => '#FROM_ROLE',
1371: avalue => l_performer );
1372:
1373: select concatenated_segments into l_from_item from mtl_system_items_kfv where rownum=1;
1374: -- get values to be stored into the workflow item
1375: l_performer_name := get_default_role('oracle.apps.gr.reg.documentmanager',l_from_item);
1376:
1377: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,