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.GML_MOBILE_RECEIPT dependencies on MTL_ITEM_LOCATIONS

Line 3320: FROM mtl_item_locations_kfv

3316: SELECT inventory_location_id
3317: , description
3318: INTO x_location_id
3319: , x_description
3320: FROM mtl_item_locations_kfv
3321: WHERE organization_id = p_org_id
3322: AND subinventory_code = p_sub_code
3323: AND concatenated_segments = p_concat_segs
3324: AND ROWNUM < 2;

Line 3357: FROM mtl_item_locations_kfv

3353: INTO l_validity_check
3354: FROM DUAL
3355:
3356: WHERE EXISTS( SELECT subinventory_code
3357: FROM mtl_item_locations_kfv
3358: WHERE concatenated_segments = p_concat_segs
3359: AND p_sub_code <> subinventory_code
3360: AND organization_id = p_org_id);
3361: EXCEPTION

Line 3381: UPDATE mtl_item_locations

3377:
3378:
3379: l_loc_type := NULL;
3380:
3381: UPDATE mtl_item_locations
3382: SET subinventory_code = p_sub_code
3383: , status_id = l_sub_default_status
3384: , inventory_location_type = l_loc_type
3385: WHERE organization_id = p_org_id

Line 3395: FROM mtl_item_locations_kfv

3391: SELECT 'failed'
3392: INTO l_validity_check
3393: FROM DUAL
3394: WHERE EXISTS( SELECT subinventory_code
3395: FROM mtl_item_locations_kfv
3396: WHERE concatenated_segments = p_concat_segs
3397: AND p_sub_code <> subinventory_code
3398: AND organization_id = p_org_id);
3399: EXCEPTION

Line 3479: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l

3475: OPEN x_Locators FOR
3476: select a.inventory_location_id,
3477: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),
3478: nvl( a.description, -1)
3479: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l
3480: WHERE b.organization_id = p_Organization_Id
3481: AND b.inventory_item_id = p_Inventory_Item_Id
3482: AND a.inventory_location_id = l.inventory_location_id
3483: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 3511: FROM mtl_item_locations_kfv a, ic_loct_mst l

3507: OPEN x_Locators FOR
3508: select a.inventory_location_id,
3509: INV_PROJECT.GET_LOCSEGS(concatenated_segments),
3510: description
3511: FROM mtl_item_locations_kfv a, ic_loct_mst l
3512: WHERE organization_id = p_Organization_Id
3513: AND subinventory_code = p_Subinventory_Code
3514: AND a.inventory_location_id = l.inventory_location_id
3515: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 3542: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l

3538: OPEN x_Locators FOR
3539: select a.inventory_location_id,
3540: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),
3541: nvl( a.description, -1)
3542: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l
3543: WHERE b.organization_id = p_Organization_Id
3544: AND b.inventory_item_id = p_Inventory_Item_Id
3545: AND a.inventory_location_id = l.inventory_location_id
3546: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 3572: FROM mtl_item_locations_kfv a, ic_loct_mst l

3568: OPEN x_Locators FOR
3569: select a.inventory_location_id,
3570: INV_PROJECT.GET_LOCSEGS(concatenated_segments),
3571: description
3572: FROM mtl_item_locations_kfv a, ic_loct_mst l
3573: WHERE organization_id = p_Organization_Id
3574: AND subinventory_code = p_Subinventory_Code
3575: AND a.inventory_location_id = l.inventory_location_id
3576: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)