DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on WMS_ITEM_LOCATIONS_KFV

Line 1241: FROM wms_item_locations_kfv

1237: CURSOR get_location (v_org_id IN NUMBER
1238: ,v_sub_inv IN VARCHAR2
1239: ,v_loc_id IN NUMBER) IS
1240: SELECT substr(concatenated_segments,1,100)
1241: FROM wms_item_locations_kfv
1242: WHERE organization_id = v_org_id
1243: AND subinventory_code = v_sub_inv
1244: AND inventory_location_id (+) = v_loc_id;
1245: l_mmti_rec mtl_transactions_interface%ROWTYPE;