APPS.GME_MOBILE_TXN dependencies on WMS_ITEM_LOCATIONS_KFV

Line 677: FROM wms_item_locations_kfv

673: FND_MESSAGE.SET_TOKEN('SUBINV', p_sub_code);
674: ELSIF p_object_type = 'L' THEN --- Locator
675: SELECT substr(concatenated_segments,1,100)
676: INTO l_locator
677: FROM wms_item_locations_kfv
678: WHERE organization_id = p_organization_id
679: AND subinventory_code = p_sub_code
680: AND inventory_location_id = p_locator_id;
681:

Line 933: wms_item_locations_kfv l

929: l.concatenated_segments,
930: TO_CHAR(transaction_date, l_date_format),
931: revision
932: FROM mtl_material_transactions m,
933: wms_item_locations_kfv l
934: WHERE trx_source_line_id = NVL(p_material_detail_id, trx_source_line_id)
935: AND transaction_source_id = p_batch_id
936: AND transaction_type_id = l_txn_type_id
937: AND l.inventory_location_id = m.locator_id(+);

Line 3455: wms_item_locations_kfv lc

3451: TO_CHAR(m.transaction_date, l_date_format),
3452: revision
3453: FROM mtl_material_transactions m,
3454: mtl_transaction_lot_numbers l,
3455: wms_item_locations_kfv lc
3456: WHERE l.transaction_id = m.transaction_id
3457: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3458: AND m.organization_id = p_organization_id
3459: AND m.transaction_source_id = p_batch_id

Line 3534: wms_item_locations_kfv lc

3530: TO_CHAR(m.transaction_date, l_date_format),
3531: revision
3532: FROM mtl_material_transactions m,
3533: mtl_transaction_lot_numbers l,
3534: wms_item_locations_kfv lc
3535: WHERE l.transaction_id = m.transaction_id
3536: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3537: AND m.organization_id = p_organization_id
3538: AND m.transaction_source_id = p_batch_id

Line 4378: FROM wms_item_locations_kfv

4374: x_error_message OUT NOCOPY VARCHAR2)
4375: IS
4376: CURSOR x_loc_lov IS
4377: SELECT inventory_location_id
4378: FROM wms_item_locations_kfv
4379: WHERE organization_id = p_organization_id
4380: AND NVL(disable_date, SYSDATE + 1) > SYSDATE
4381: AND subinventory_code = p_subinventory_code
4382: AND concatenated_segments = p_locator_code;

Line 4386: FROM wms_item_locations_kfv a,

4382: AND concatenated_segments = p_locator_code;
4383:
4384: CURSOR x_loc_lov1 IS
4385: SELECT a.inventory_location_id
4386: FROM wms_item_locations_kfv a,
4387: mtl_secondary_locators b
4388: WHERE b.organization_id = p_organization_Id
4389: AND b.inventory_item_id = p_Inventory_Item_Id
4390: AND b.subinventory_code = p_Subinventory_Code

Line 4436: FROM gme_material_details m, wms_item_locations_kfv loc

4432: IS
4433: CURSOR c_subinv_loc IS
4434: SELECT subinventory, loc.concatenated_segments,
4435: m.locator_id
4436: FROM gme_material_details m, wms_item_locations_kfv loc
4437: WHERE m.subinventory = loc.subinventory_code (+)
4438: AND m.locator_id = loc.inventory_location_id (+)
4439: AND m.batch_id = p_batch_id
4440: AND m.material_Detail_id = p_material_detail_id;