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_KFV

Line 1330: FROM mtl_item_locations_kfv

1326:
1327: /*Added by sowsubra*/
1328: CURSOR c_get_subinv_loc_dtls(p_inv_locator_id IN NUMBER, p_org_id IN NUMBER) IS
1329: SELECT SUBINVENTORY_CODE, CONCATENATED_SEGMENTS
1330: FROM mtl_item_locations_kfv
1331: WHERE inventory_location_id = p_inv_locator_id;
1332:
1333: l_sub_code VARCHAR2(10) := NULL;
1334: l_locator_code VARCHAR2(240) := NULL;

Line 1801: from mtl_item_locations mil, mtl_item_locations_kfv milk

1797: CURSOR c_loc_validate (p_org_id IN NUMBER, p_subinv_code IN VARCHAR2, p_loc_seg IN VARCHAR2) IS
1798: -- jaramana on Feb 14, 2008 for bug 6819370
1799: -- Made segment19 and segment20 refer to base table
1800: SELECT mil.inventory_location_id
1801: from mtl_item_locations mil, mtl_item_locations_kfv milk
1802: where mil.organization_id = p_org_id
1803: and mil.subinventory_code = p_subinv_code
1804: and milk.concatenated_segments = p_loc_seg
1805: and mil.segment19 is NULL

Line 3483: from mtl_item_locations mil, mtl_item_locations_kfv milk

3479: CURSOR c_loc_validate (p_org_id IN NUMBER, p_subinv_code IN VARCHAR2, p_loc_seg IN VARCHAR2) IS
3480: -- jaramana on Feb 14, 2008 for bug 6819370
3481: -- Made segment19 and segment20 refer to base table
3482: SELECT mil.inventory_location_id
3483: from mtl_item_locations mil, mtl_item_locations_kfv milk
3484: where mil.organization_id = p_org_id
3485: and mil.subinventory_code = p_subinv_code
3486: and milk.concatenated_segments = p_loc_seg
3487: and mil.segment19 is NULL