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.AHL_MC_ITEMGROUP_PUB dependencies on AHL_MTL_ITEMS_NON_OU_V

Line 484: FROM ahl_mtl_items_non_ou_v

480: -- For inventory_item_id.
481: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,
482: p_inv_organization_id IN NUMBER) IS
483: SELECT inventory_item_id
484: FROM ahl_mtl_items_non_ou_v
485: WHERE concatenated_segments = p_inventory_item_name
486: AND inventory_org_id = p_inv_organization_id;
487:
488: -- For concatenated segments.

Line 492: FROM ahl_mtl_items_non_ou_v

488: -- For concatenated segments.
489: CURSOR mtl_segment_csr(p_inventory_item_id IN NUMBER,
490: p_inv_organization_id IN NUMBER) IS
491: SELECT concatenated_segments
492: FROM ahl_mtl_items_non_ou_v
493: WHERE inventory_item_id = p_inventory_item_id
494: AND inventory_org_id = p_inv_organization_id;
495:
496: -- For item association id.

Line 514: l_concatenated_segments ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;

510: l_item_association_id NUMBER;
511: l_item_group_id NUMBER;
512: l_lookup_code fnd_lookups.lookup_code%TYPE;
513: l_return_val BOOLEAN;
514: l_concatenated_segments ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
515: l_dummy varchar2(200);
516:
517: BEGIN
518: