APPS.GML_MOBILE_RECEIPT dependencies on IC_LOCT_MST

Line 58: FROM ic_loct_mst

54:
55: IF p_locator_id > 0 THEN
56: SELECT location
57: INTO v_location
58: FROM ic_loct_mst
59: WHERE inventory_location_id = p_locator_id;
60: ELSE
61: v_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
62: END IF;

Line 300: from ic_loct_mst

296: BEGIN
297:
298: OPEN x_location_lov FOR
299: select distinct location, NVL(loct_desc, location), INVENTORY_LOCATION_ID
300: from ic_loct_mst
301: where whse_code = p_whse_code and delete_mark = 0 and
302: location like (p_location) and
303: location <> l_default_loc;
304:

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)