APPS.GME_MOBILE_TXN dependencies on WMS_ITEM_LOCATIONS_KFV

Line 586: FROM wms_item_locations_kfv

582: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
583: ELSIF p_object_type = 'L' THEN --- Locator
584: SELECT substr(concatenated_segments,1,100)
585: INTO l_locator
586: FROM wms_item_locations_kfv
587: WHERE organization_id = p_organization_id
588: AND subinventory_code = p_sub_code
589: AND inventory_location_id = p_locator_id;
590:

Line 842: wms_item_locations_kfv l

838: l.concatenated_segments,
839: TO_CHAR(transaction_date, l_date_format),
840: revision
841: FROM mtl_material_transactions m,
842: wms_item_locations_kfv l
843: WHERE trx_source_line_id = NVL(p_material_detail_id, trx_source_line_id)
844: AND transaction_source_id = p_batch_id
845: AND transaction_type_id = l_txn_type_id
846: AND l.inventory_location_id = m.locator_id(+);

Line 3359: wms_item_locations_kfv lc

3355: TO_CHAR(m.transaction_date, l_date_format),
3356: revision
3357: FROM mtl_material_transactions m,
3358: mtl_transaction_lot_numbers l,
3359: wms_item_locations_kfv lc
3360: WHERE l.transaction_id = m.transaction_id
3361: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3362: AND m.organization_id = p_organization_id
3363: AND m.transaction_source_id = p_batch_id

Line 3438: wms_item_locations_kfv lc

3434: TO_CHAR(m.transaction_date, l_date_format),
3435: revision
3436: FROM mtl_material_transactions m,
3437: mtl_transaction_lot_numbers l,
3438: wms_item_locations_kfv lc
3439: WHERE l.transaction_id = m.transaction_id
3440: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3441: AND m.organization_id = p_organization_id
3442: AND m.transaction_source_id = p_batch_id

Line 4248: FROM wms_item_locations_kfv

4244: x_error_message OUT NOCOPY VARCHAR2)
4245: IS
4246: CURSOR x_loc_lov IS
4247: SELECT inventory_location_id
4248: FROM wms_item_locations_kfv
4249: WHERE organization_id = p_organization_id
4250: AND NVL(disable_date, SYSDATE + 1) > SYSDATE
4251: AND subinventory_code = p_subinventory_code
4252: AND concatenated_segments = p_locator_code;

Line 4256: FROM wms_item_locations_kfv a,

4252: AND concatenated_segments = p_locator_code;
4253:
4254: CURSOR x_loc_lov1 IS
4255: SELECT a.inventory_location_id
4256: FROM wms_item_locations_kfv a,
4257: mtl_secondary_locators b
4258: WHERE b.organization_id = p_organization_Id
4259: AND b.inventory_item_id = p_Inventory_Item_Id
4260: AND b.subinventory_code = p_Subinventory_Code

Line 4306: FROM gme_material_details m, wms_item_locations_kfv loc

4302: IS
4303: CURSOR c_subinv_loc IS
4304: SELECT subinventory, loc.concatenated_segments,
4305: m.locator_id
4306: FROM gme_material_details m, wms_item_locations_kfv loc
4307: WHERE m.subinventory = loc.subinventory_code (+)
4308: AND m.locator_id = loc.inventory_location_id (+)
4309: AND m.batch_id = p_batch_id
4310: AND m.material_Detail_id = p_material_detail_id;