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.EGO_PUBLICATION_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 200: FROM mtl_system_items_vl msiv, org_organization_definitions orgdef,mtl_system_items_b_kfv kfv

196: XMLELEMENT("ID",itemId),
197: XMLELEMENT("ContextID",XMLATTRIBUTES(orgIdStr AS "SchemeID"),orgId),
198: XMLELEMENT("Name",kfv.concatenated_segments)))
199: INTO x_doc
200: FROM mtl_system_items_vl msiv, org_organization_definitions orgdef,mtl_system_items_b_kfv kfv
201: WHERE msiv.inventory_item_id = kfv.inventory_item_id AND
202: msiv.organization_id = kfv.organization_id AND
203: msiv.organization_id = orgdef.organization_id AND
204: msiv.inventory_item_id = itemId AND

Line 260: FROM mtl_system_items_vl itemvl,org_organization_definitions orgdef,

256:
257: CURSOR C1 IS
258: SELECT
259: lc.element_number,lcphase.element_number
260: FROM mtl_system_items_vl itemvl,org_organization_definitions orgdef,
261: pa_ego_lifecycles_v lc,pa_ego_phases_v lcphase
262: WHERE itemvl.lifecycle_id = lc.proj_element_id AND
263: itemvl.current_phase_id = lcphase.proj_element_id AND
264: itemvl.organization_id = orgdef.organization_id AND

Line 334: FROM mtl_system_items_vl itemvl,org_organization_definitions orgdef

330: XMLELEMENT("BaseUOMCode",itemvl.primary_uom_code),
331: XMLELEMENT("SecondaryUOMCode",itemvl.secondary_uom_code),
332: XMLELEMENT("CreationDate",itemvl.creation_date)))
333: INTO x_doc
334: FROM mtl_system_items_vl itemvl,org_organization_definitions orgdef
335: WHERE
336: itemvl.organization_id = orgdef.organization_id AND
337: itemvl.inventory_item_id = itemId AND itemvl.organization_id = orgId;
338: