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_VWP_VISITS_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1124: FROM mtl_item_locations_kfv

1120:
1121: /*Added by sowsubra*/
1122: CURSOR c_get_subinv_loc_dtls(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS
1123: SELECT SUBINVENTORY_CODE, CONCATENATED_SEGMENTS
1124: FROM mtl_item_locations_kfv
1125: WHERE inventory_location_id = p_inv_locator_id;
1126:
1127: l_sub_code VARCHAR2(10) := NULL;
1128: l_locator_code VARCHAR2(240) := NULL;

Line 1515: from mtl_item_locations mil, mtl_item_locations_kfv milk

1511: CURSOR c_loc_validate (p_org_id IN NUMBER, p_subinv_code IN VARCHAR2, p_loc_seg IN VARCHAR2) IS
1512: -- jaramana on Feb 14, 2008 for bug 6819370
1513: -- Made segment19 and segment20 refer to base table
1514: SELECT mil.inventory_location_id
1515: from mtl_item_locations mil, mtl_item_locations_kfv milk
1516: where mil.organization_id = p_org_id
1517: and mil.subinventory_code = p_subinv_code
1518: and milk.concatenated_segments = p_loc_seg
1519: and mil.segment19 is NULL

Line 2886: from mtl_item_locations mil, mtl_item_locations_kfv milk

2882: CURSOR c_loc_validate (p_org_id IN NUMBER, p_subinv_code IN VARCHAR2, p_loc_seg IN VARCHAR2) IS
2883: -- jaramana on Feb 14, 2008 for bug 6819370
2884: -- Made segment19 and segment20 refer to base table
2885: SELECT mil.inventory_location_id
2886: from mtl_item_locations mil, mtl_item_locations_kfv milk
2887: where mil.organization_id = p_org_id
2888: and mil.subinventory_code = p_subinv_code
2889: and milk.concatenated_segments = p_loc_seg
2890: and mil.segment19 is NULL